How to configure the expand and collapse features in pivot table

[#1]

Hi All,

I need help on the following pivot table configurations:

1. When I click on (1) [Capture001], I will get [Capture002], which is what I am expecting.

2. When I click on (2) [Capture001], I will get [Capture003], which is not good for me.
3. After I get [Capture002] when I click on ‘Bond’ I will then get [Capture004], again, this is not good for me too.

4. I am trying to achieve: regardless I click on (1) or (2) in [Capture001], I will always get the result as shown in [Capture002] only. Alternatively to disable the clickable function of (2) would be a great solution for me.

I have attached my working file as Razor for your advices.

Many Thanks!
Heok

[m_woolf]

You have Suppress When Value is Null checked for every dimension.

When I uncheck for all but the 1st dimension, the pivottable behaves much better.

[Gysbert_Wassenaar · Accepted solution]

Change your expressions to disregard some or all selections. For example to disregard all selections:

Change

     SUM({<keyExpType={'MTM'}>}peakUtilization)

into:

     SUM({1<keyExpType={'MTM'}>}peakUtilization)

If you want to disregard selections in specific fields you can do that too. For example

     SUM({<KeyProduct=,keyExpType={'MTM'}>}peakUtilization)

See attached qvw.

[#4]

I go for the solution of SUM({1<keyExpType={'MTM'}>}peakUtilization). It does just what I need! Thanks!