
1. Re: Incorrect Subtotals for calculation using the Fixed expression
Deepak Rai Aug 4, 2018 1:48 PM (in response to Progenthusiast)What Happens when you keep cursor at Subtotal, Is the Menu Displays Automatic? If It is, Change it to SUM. If That Does n't Work,please attach a workbook.
Thanks
Deepak

2. Re: Incorrect Subtotals for calculation using the Fixed expression
Progenthusiast Aug 4, 2018 7:45 PM (in response to Deepak Rai)I tried it. SUM is the default. It is still displaying the cumulative percent. I have attached the Tableau example. The subtotals get displayed as 300% and the grand total is 1200% which are incorrect. Thanks a lot again!

Test.twbx 1.2 MB


3. Re: Incorrect Subtotals for calculation using the Fixed expression
Deepak Rai Aug 4, 2018 11:21 PM (in response to Progenthusiast)Pl Check attached. When Using Fixed since you are aggregating Each Category in a year, so You are likely to get it that way. I changed your Calc to Table Calculation to get it.
Thanks
Deepak

Test (6)_v10.2.twbx 1.2 MB


4. Re: Incorrect Subtotals for calculation using the Fixed expression
Progenthusiast Aug 5, 2018 12:56 PM (in response to Deepak Rai)I used a Table Calculation earlier and it is good when I don't use calculated dimensions and parameters to swap the columns. When I do so, all the dimension pairs don't display the correct percent using a Table Calculation as I can compute the percent based on only one dimension, so I would need a fixed expression to compute the percents for different dimension pairs. Would there a way a to display the correct percents when using the fixed expression?
Thanks!

5. Re: Incorrect Subtotals for calculation using the Fixed expression
KANTHESH M.D Aug 5, 2018 11:13 PM (in response to Progenthusiast)Hey Hi,
Check out this workbook,i think it might help you.
Regards,
Kanthesh

Test.twbx 1.2 MB
