Hi Deepak Rai! Thank you for your answer, it was really helpful. However, I still have a problem. Values ( 2, 4, 5) aren't a dimension, but they are the result of a counting. I mean, if I put everything on a table, it would be something like that:
Activity Name Count
Gym Peter 4
Pool Peter 5
What I get using your formula is gym = 50% and Pool = 50% (sum of each activity = 15, total is 30 so 50% each one). However, my goal is to get the percentage of the number. I mean:
Activity Number %
Gym 4 50%
Pool 5 50%
I'd be really grateful if you could tell me when to do it.
I used LOD, and FIXED LOD can be used as Dimension. Since I don't have data like yours , I created this sample from Superstore . You can use my detailed explanation thing or Single LOD, both will give you same values.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
LOD for LOD_v10.4.twbx 2.5 MB
Thank you Deepak!! Problem solved
1 of 1 people found this helpful
Please please close the THREAD by marking my reply as Helpful and CORRECT . You would help others in similar situation. The CORRECT button is under my reply in your main thread not in email.