Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all i want to calucalte the % for the 3 measures based on dimension and i have type service and hadrware
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
I think Island Table is the best way to get the desired result.
For separat tables see attached
Hi Sunny Talwar any idea on this?
sum(Value)
/
sum(TOTAL <Sales_Stage> Value)
This way you get the percentage value per Sales_Stage.
What is the expected output in numerical terms for the sample data provided?
Hi Sunny Talwar this is expected output for the example
maybe like attached!
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.
I think Island Table is the best way to get the desired result.
For separat tables see attached
it seems same way its looking .. i will test in my original dashboard and close the thread thank you good night
maybe you can also try using calculated dimension to achieve desired output.
see attached