Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have 3 different fields i.e
Order = Pool Cars
Amount in Local Currency = Budget
Assignment = Assigned Cars
And i have to show all these like this in a pie chart.
can anyone show me how would that be possible.
Hi, you can create a calculated dimensions as =ValueList('Order','Amount','Budget')
And an expression like:
Pick(Match(ValueList('Order','Amount','Budget')
,'Order','Amount','Budget')
,[ExpressionForOrder]
,[ExpressionForAmount]
,[ExpressionForBudget]
)