As an example, below is one record which is split by 6 country codes:-
The grand total is correct at 31.00. However, I need the sum at each row level to be the grand total (31.00) divided by the number of separate country codes (6), so the final result would read:-
Grand Total 31.00
I have tried WINDOWS_SUM and all sorts, but I cannot think of the methodology!
Many thanks in advance.
Could you pls share the data or twbx?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...