Group expressions in rows to allow expand/collaps function

[#1]

Hello,

Is it possible to group expressions and then be able to expand collaps them in a pivot table (like you can do with dimensions)

So, in below picture I have an expression for each row. I would like to be able to group Quant var dir mat --> stock-taking, cost as they sum up to mat and procurem var and then be able to expand/collaps with +/- symbol.

Is there an easy way to do this?

[sunny_talwar · Accepted solution]

May be couple of ways

1) Create synthetic dimensions and add those expression as a dimension and use a single expression

2) May be create a text object with +/- sign and conditionally hide show expressions based on button click

[#3]

Ok, not an answer I was hoping for

Neither options seems like good options for me as I would need quite a lot of them. Then I guess the users will have to live with fully expanded rows.

I was hoping there was a built in function that could solve it.

Thanks anyway Sunny.

[sunny_talwar]

Don't like the second option as well? Its not that difficult to do this...

[kamal_sanguri]

I totally agree that second option suggest ed by stalwar1‌ is quite practical and should be quickly to implement

[#6]

Well, but I am afraid that the relative postion of +/- sign will be very confusing for the users if some are expanded and some are not.

See below. So If I would go for option 2 and have the table expanded, then the +/- sign will not be positioned next to the correct row, right?

[sunny_talwar]

You can use two buttons instead of 1... but yes it will not be as easy as an inbuilt thing....

[kamal_sanguri]

How about using two buttons, where one button will expand the Chart to fullest and other one will collapse it.  You can a use a variable and set it to 0 or 1 on button/text box press actions and use this variable to show/hide two pivot chart (one which is fully expanded and other one would be the current chart you have.

[kamal_sanguri]

I mean, if you can consider placing those two text box/buttons not in the chart (so you don't have to worry about their relative position) may be above the chart (where it can attract user quickly)

[#10]

Hello guys!

Ok, that would probably be better than nothing.

If you have time I would highly appreciate if you could tell me what to type in as conditional formula and how to link it to the +/-image