Hello Team,
I have a pivot table for a segment table, which provides forecast variability values for each segment value.
The problem is, forecast variability calculation takes 2 additional fields to provide accurate result for segment, and due to this, we have to specify 2 fields in pivot table, which is not required visually.
We have collapsed the 2 fields and hidden the expand button to hide the expand field. It works in the analysis and dashboard just fine with the existing data. But, when new data is introduced in segment, the new data expands in default, even though the existing ones have been collapsed by us. is there any way to tackle this?