I have the data in my table as a result of an expression.How we can get the below bolded format in design level.
Segement(DIM1) Sub-seg(DIM2) Exp1 >=50000 and <=100000 >100000 and <=150000
TC TC-Azc 90000 1 -
TC TC-Apc 150000 - 1
TC TC-BCP 100000 1 -
TC TC-BCL 150000 - 1
Total :490000 2 2
The Sub-seg field is not required in table level as a dimension.So then
Segement(DIM1) Exp1 >=50000 and <=100000 >100000 and <=150000
TC 490000 2 2
Thanks in advance,
As you dont want to show Sub-seg(DIM2), go to presentation tab and choose the Hide Column and for the next two expressions in Presentation tab select respecpective expressions and write in Column Label
>=50000 and <=100000 and >100000 and <=150000 respectively.
then there is a simple solution.
Don't mark the 'Always Fully Expanded' check box in the 'Presentation' tab and collapse Sub-seg(DIM2) dimension.
Hope this helps