Restrict Expansion in Pivot Table

[#1]

Hi

I have a Pivot table with two Dimensions and with the expression of PTD figures for the Financial Year for the P &L.

My First Dimension is used valueList() as I needed to group them in unique order as well as grouping.Second Dimension is Database field and calculate the expression using Set Analysis.

I want to Restrict the Expansions for Grey lines as per my attached Excel Sheet Table2. Otherwise it duplicate the second Dimensions again as Table 1 in the sheet.I tried to use 'Enable Conditional Option' but it didn't work for me.

I also tried to use valuelist() for my second Dimensions and worked perfectly but it is really slow...

Can you please advice.

Thank you.

Harsh

[ecolomer]

You can introduce an column with the level as you can see in the file

[#3]

Hi Enrique

How this is going to work? This data is coming from SQL table and stored in qvd. Can you expain bit more the way your idea is working?

Thanks

Harsh

[ecolomer]

Yes, with conditional view

[#5]

Hi Enrique

I have tried it and didn't work for me. Can you send me the sample if possible ?

Regards

Harsh

[#6]

Hi Enrique

I have finally used with Excel template and did work for me.

Thanks for your help

Regards

Harsh