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.
