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 %
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))