i have a straight table with some dimensions as Branch, Lead BDM and some expressions(which is calculated using conditional formulas). all the expressions do not have sum() calculation. so i have made a total of the rows and that total is displayed on top.
Now, i need to make another pivot table which should display only the total of the dimensions named Lead BDM.
the problem is the calculation of expressions depends on the particular branch. so if i hide the branch column in pivot table, some values are showing null
i have lead BDM names as
Now i have to make a table showing the totals alone.
i.e., Total: Lead BDM Andy,
Total: Lead BDM Antony,
Total: Lead BDM Nick, etc... with all the same expressions (total alone).