Pie Chart Problem

[Brownie]

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.

[rubenmarin]

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