How to get rid of summary column on a pivot table that I exported from BI Service

[wpf_]

I did a analyzed from excel from power bi service and I was able to pretty much build the matrix back up via a pivot table.  But there is this pesky summary column that I can't get rid of.  I turned off grand total and subtotal, but this still persists.  Can anyone tell me how to get rid of it?  Thanks

[FrankAT · Accepted solution]

Hello @wpf_

you can try to build a non-asynchronous set:

1. PivotTable Analysis > Fields, Items, and Sets > Create Set Based on Column Elements...
2. Delete the items that you want to dispose of.

With kind greetings from the city where the legend of 'Pied Piper de Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[wpf_]

@FrankAT ,

Wow that did it, Thank you! I will mark this as a solution.

I also have a question with exporting a report from BI service to excel (not analyze from excel).  And in this report I actually need the grand totals, but the grand totals are not correct (everything else is).  Can i @ you tomorrow with a new post?  Thanks again. 

[Greg_Deckler]

@wpf_ - Should be an option to turn off column totals

[wpf_]

@Greg_Deckler ,

I already had that row and column subtotals turned off in the matrix in PBI, but when I analyzed in excel it still shows up.  

[Greg_Deckler]

@wpf_ - Oh, I am not aware of how to turn that off in Excel, sorry, I should have looked closer at the pic!