Forum Discussion
Anonymous
7 years agoNot applicable
Table visual - group by
Hi, Based on below Sample Table Data, I have tried and able to display the data in Table visual. Refer Image 1 Region Location Item Volume Region1 Location4 Item2 2968 ...
mahenkj2
4 years agoSolution Sage
Hi Anonymous ,
Since you have reached so far, to get most work done with the table visual, I would see potential possibility to make it closer to your desired result (need to check).
If possible, add a running index to Region, so first instance of Region change is 1 else say 2, and then with addition to background formatting, also use Font formatting based on Rule with this running index. Use a matching color to background when second event of region appears. Not sure, if this will be working as you intend but another workaround to test!