Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have attached a sample snapshot where I have to add the two rows values of hierarchy level 00 and 01 and 05 and 06. How to do so?
so that I will be sorting my data like
00-01
02
03
04
05-06
Use a calculated dimension;
If(Match(HierarchyLevel, '00', '01', Dual('00-01', 0),
If(Match(HierarchyLevel, '05', '06', Dual('05-06', 1000), HierarchyLevel))