percentage

[soniasweety]

Hi all i want to calucalte the % for the   3 measures based on dimension  and i have type  service and hadrware

Marco Wedel

tresesco

Andrea Gigliotti

dimension values

salestge

01-cust

02-vali

03-qua

04-dev..

05-negative.......  like that

i want

service%  =    sum(01+02)/All_salestge    = where type is  service

   hardware% = sum(01+02)/All_salestge    = where type is  hardware

total%    = sum(01+02)/All_salestge   

[soniasweety]

Hi Sunny Talwar  any idea on this?

[niclaz79]

sum(Value)

/

sum(TOTAL <Sales_Stage> Value)

This way you get the percentage value per Sales_Stage.

[sunny_talwar]

What is the expected output in numerical terms for the sample data provided?

[soniasweety]

Hi Sunny Talwar  this is expected output for the example

[Frank_Hartmann]

maybe like attached!

[soniasweety]

instead of hard coding  is there any other way to get dynamic?

and i want two seperate tables  in attached image the same way they wanted to see

top table should have the totals

below it with percentages.

[Frank_Hartmann · Accepted solution]

I think Island Table is the best way to get the desired result.

For separat tables see attached

[soniasweety]

it seems  same way its looking  .. i will test in my original dashboard and close the thread thank you good night

[Frank_Hartmann]

maybe you can also try using calculated dimension to achieve desired output.

see attached