Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dimension1: Month
Dimension 2:=ValueList('LocalSales','Export','IntercompanySales')
Measure :=pick(match(ValueList('LocalSales','Export','IntercompanySales'),'LocalSales','Export','IntercompanySales')
,sum(LocalSales),sum(Export),sum(IntercompanySales))
for Total :sum(LocalSales)+sum(Export)+sum(IntercompanySales)
i need to calculate %
Month | SalesType | Value | TotalSale | Percentage |
JAN | LocalSales | 100 | 2400 | 4.166666667 |
JAN | Export | 2000 | 2400 | 83.33333333 |
JAN | IntercompanySales | 300 | 2400 | 12.5 |
i need help to get last measures Percentage
salesType is not direct Dimension i used valueList
it works with below thank you
=pick(match(ValueList('LocalSales','Export','IntercompanySales'),'LocalSales','Export','IntercompanySales')
,sum(LocalSales),sum(Export),sum(IntercompanySales))/
(sum(LocalSales)+sum(Export)+sum(IntercompanySales))