Maybe put the totals in a separate sheet and place them together in a dashboard?
Thanks for the response Nasir Khan . but how do I do this calculation to get the desired out in another sheet . Sorry I am fairly new to tableau .
Hi Satya ,
Thanks for the above - I have used the calculated field . But now I have another issue for the same
For the subcategory = Rate type = failed value I need the calculation Aggregate Failed value / Aggregate Total Value and same for the volume .
I have created two calculated columns one as below ;
aggr_failed = If [sub_category] = 'Aggregate' and type = 'Failed' then figures . likewise create another for Aggregated Totals.
create another calculated field = if sub_category = 'Rate' then aggr_failed/aggr_total.
But when I use the calculated field it showing null values !
Would you please help me on this ?