This content has been marked as final.
Show 2 replies
-
1. Re: Percent of Average Table Calculation Help
Jim DehnerJan 25, 2019 11:48 AM (in response to Nicholas Reiff)
Hi
see the attach superstore example
Grand totals can't be used in a calculation but you can do this
use an lod to determine the yearly avg
then use that to determine the percentage
it returns this
You mentioned the values in your avg were calculated - if so you may need to make them lods also then then nest that LOD in the calculations above
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
avg percentage.twbx 2.3 MB
-
-
2. Re: Percent of Average Table Calculation Help
Deepak RaiJan 25, 2019 11:55 AM (in response to Nicholas Reiff)
I used Superstore Data.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
Thanks
Deepak
-
Avg Division.twbx 1.2 MB
-