- Go to Analysis >Uncheck Aggegate Measures.
- Create a Calc with INDEX(), Convert to Discrete and bring as First Pill in Rows and Uncheck Header
If this Helps, Pl Mark it Helpful and CORRECT to Close Thread
abc excess example_v10.5.twbx 24.6 KB
Thanks all - seems there are a few ways to approach
In a "perfect" world would prefer to not have a the third column
Your approach Deepak does this, however is it possible to not have repeating dates? i.e. 1/2/2019 is repeated twice in the column below each other.
Ideally I'm seeking a format like Zhoyi's where the date isn't repeated - but no third column