how to show only few conditional dimension values in a table
Hi,
I have a straight table chart as below, where in dimension have to show Number and Version by joining them.
Another column is p which shows the pth numbers.
Number - Version
p
Total
20.0.18362-May 2019 update
p-3
5
20.0.18363-June 2019 update
p-2
3
20.0.19363-June 2019 update-22H2-May 2020 update
p-1
13
20.0.19363-update-23H2
p+1
52
20.0.19362-update-23H1
p+2
4
20.0.20000-update
p
83
Greater than 20.0.20000-update
p+
9
Now requirement is like this table should show only the values of “p”, “p-1”, and “p+”. For the row that is being aggregated which is the “p+”, this should show the values greater than 20000 .
for this I am writing below condition but unable to eliminate other values from table. ideally only three rows should be there along with additional 10p+ values
=if([number]='Greater than 20.0.20000','p+', if(version='update-23H2','10p+', if(version='update-23H1','10p+', if([number]= SubField('20.0.20000','.',3),'p', p))))
Please suggest what changes do I need to make in expression.