Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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,
Are you using the same dimensions in combo chart as in pivot? Perhaps not. Could you share your sample app?