Grand total of subtotals

Question

Hi I am using OBI 12.2.1.2.0

Can someone tell me how to add grandtotal of subtotal to pivot view, i have a subtotals by stores  where i count how many products are sold on my analysis

but i want to have a grandtotal of all stores , I dont see option for that

Thx, Matija

Robert Angel · Answer

Like this?

If so, achieved by ticking totals after for Accounting Year and then totals after for rows (the sigma tick)