The reason that the subtotals are not showing is because the measure is set to discrete. Discrete measures cannot be totaled because they are no longer technically considered measures. As a workaround, you could create a couple different worksheets and place them on the dashboard together so that the TPI will show the subtotal and you can place it in the correct/desired column.
Hope this helps!
Thanks for your reply.
Revenues are devided based on diff. columns data,i.e,disaggregation, if i reduce the columns, then the data will get aggregated,fortunately,i have a diff. case,thanks. Is there any way to hide columns or simply squizzing and painting white need to be worked.