You need to use LOD expressions.
Please check the below links,it will help you out.
Hope it helps you.
1 of 1 people found this helpful
Thx for replying.
The situation is that let say
Assuming Store normally has 1 department, and there is a exceptional case where a store has 2 departments, for report purpose (table) , it may be strange to has 0 sales in department (as below). So that why i want to show the same sales value to the depart while keeping the total accurate.
Store Depart Sales
A A1 100
B B1 100
B B2 0
C C1 100
Thank you for the kind scenario description
Got it !
thx for your help too which expand my exp in Tableau (Thx again) . If you have time and interested in .
may i ask you one more question please . i have upload to below link. thx