Remove Value from the body of a Pivot table but Include in the Total

I have a pivot table. I’d like to show a total without displaying it in the values of the pivot table.

hello @iamsam I dont think is duable with pivot object in QS. I would go either with a table and try to create a calculated field for the total with level aware calculation or keep pivot remove the totals and display the totals in a separate table in the dashboard close to the table a bit of a hack . cheers

1 Like