Are you filtering Category? There are absolutely ways of getting what you want.
Yes I am filtering over Category and have selected 'A' Product category.
See the attached - we can use total(sum([sales])) to get the total accross all (set to Table Down), but the filtering still breaks this.
We use a special filter that 'tricks' Tableau into returning all of the rows for the total on sheet 2.
filter.twbx.zip 1.1 MB
Thanks Alex ,
It is working fine now but here is something more I need from you , I appreciate your cooperation.
When Sub-Category is on X-Axis it should group data to sub-category:
Sale(a) : 1
Sale(b) : 2
Total Sale(a) : 36
Total Sale(b) : 42
Here in place of total sale it gives me 78 , may be it is not grouping data to sub - category so how can I do that in my measure?