Expression Issue

[Karahs]

Hello Everyone,

I have a Pick(Match()) expression which i am using in a Pivot Table wherein i get all my values correctly, the same i want to use in a Combo Chart. But since i have used Pick(Match()) chart shows blank value. I want values to display without doing any selction. I hope i am clear with the question, also attaching the result which i am getting:

Pivot Table

Combo Chart

Expected Result

Expression:

=Pick(Match(_StoreSortOrder,'1','2','3'),

Date(Opening_Date),
num(sum([Days of Operations in the month]),vNumFormat),
Num(sum([No. of Tickets (000)] * 1000)/Sum([Days of Operations in the month]),vNumFormat))

Thanks,

[tresB]

Are you using the same dimensions in combo chart as in pivot? Perhaps not. Could you share your sample app?