I have a Pivot table fed by OLAP data from Power BI.
This is pivoted in Excel
When I right click to "expand" a specific row ("Revenues) in the Pivot table (as opposed to "Expand entire field" , it does that .. expands all "Revenues" rows in that group and in other groups (which I do not wish to expand) also.
I do not get this issue with Pivot tables which run from an Excel based data list , only those drawing down OLAP data from Power BI
Any suggestions ?
Thanks
This is pivoted in Excel
When I right click to "expand" a specific row ("Revenues) in the Pivot table (as opposed to "Expand entire field" , it does that .. expands all "Revenues" rows in that group and in other groups (which I do not wish to expand) also.
I do not get this issue with Pivot tables which run from an Excel based data list , only those drawing down OLAP data from Power BI
Any suggestions ?
Thanks