The logic which you have mentioned above is likely suggested to show different numbers for totals and otherwise.
Take a look at simple table below
Totals in Tableau are calculated using different queries. As per above snapshot you will see that total shows size=1.
size is table calculation (means it is based on a data what you see in a view only)
Thank you for your quick response.
So, for my understanding. The Size function calculates the amount of rows in the view for each first dimension of the crosstab.
Your first dimension is category, my first dimension is customer. Is this assumption correct?
Second question, what if for example Furniture has only 1 subcategory? As you can see my my first customer has only 1 entry is his size also 1 then?
(Or maybe better how do I add such a column like you did to calculate whatever size is calculating?)
It is not necessarily first dimension in a view. Results may vary based on how to set table calculations
Like in below case using Table Down, I am saying return overall size for sub category, manufacturer combination. i.e 22
Total=4 i.e number of subcategories in view
In below scenario, I am saying give me size for each subcategory based on manufacturers available in a view i.e you see copiers(4),Labels(5) etc
Total=1 as we need to get results for each pane.
In below scenario, computation is set to provide results for sub-category and manufacturer based on size calculated for sub-categories.
You can have a look at below video for better understanding.
Thank you, this solved my answer