Is there a way to flatten the pivot table in the M365 Add in using excel?
For example - where you have two different entities in the rows it seems to nest them so you can expand and collapse them - all in the same column. Ideally I'd like to show them as two separate columns. Eg if you have division and customer - it would show division in column and customer in column B - with the division being repeated for each customer in the division?
There was an option in the old add in for this, but I can't find the option in the new microsoft 365 add in?
