Using dimensions from datamodel and synthetic dimension in Valuelist function

[neelamsaroha157]

Hi everyone,

I have a format of a report that I want to achieve with the maximum optimization as the calculations are too complex.

Currently I tried using :

Dim:

=Pick(Match(Dim, 'Quarter Year', 'YTD','Synthetic Dim 1', 'Synthetic Dim 2', 'Synthetic Dim 3'),

         [Quarter Year],'YTD','Synthetic Dim 1', 'Synthetic Dim 2', 'Synthetic Dim 3' ) --where Dim is an field from inline for these Dimension names.

Then In expression I am using Pick and Match.

I am able to achieve the result till Rolling quarter but when I am adding another dimension to my Calculated Dimension, its not working.

I hope I am able to explain myself...

Any help would be appreciated

Thanks in advance.

[sunny_talwar]

Very difficult to say what might not be working without looking at a sample. Would you be able to provide one?

[neelamsaroha157]

Hey Sunny,

Thanks for your reply.

I have tried to create the sample data and highlighted the calculation in yellow on 1st sheet and sheet 2 & 3 has data.

Thanks

[sunny_talwar · Accepted solution]

Neelam it might be helpful if you can share the qvw you have thus far. I am not sure what all expressions you have and how you reach them. I might be able to figure them out, but it can take me hours.

Best,

Sunny

[neelamsaroha157]

Hey Sunny,

Sorry to make it hard for you..

I have prepared the sample qv as well and everything seems to work fine in that.

But not able to figure out whats wrong in real scenario and I know you cannot help in that.

In real scenario I am able to get everything but either [Month Year] or [Quarter Year], not both..

Thanks