This content has been marked as final. Show 2 replies
Calculating percent from 1st index of each column to remaining.
eg: 1st index value of column 1: 18 and following index values are 7, 13, 10, 7 so on.
Then the percent calculation should be: 7/18, 13/18, 10/18, 7/18 ..
Similary if 1st index of column 2: 73 and following index values are 46, 37, 31, 25 so on.
The the percent calculation should be: 46/73, 37/73, 31/73, 25/73 ..
I have used tableau calculation: sum(quantity)->percent from -> compute using : table(down then across) -> relative to : First.
Is there any way to restart the quick table calculation relative to first for every column dimension?