Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to create table with Yes or No. Yes and highlighted with No
T1:
LOAD * INLINE [
ID, Date
1, 2015
1, 2016
1, 2018
2, 2017
2, 2018
3, 2015
3, 2016
3, 2017
3, 2018
4, 2016
];
Pivot Table:
Dimension1 = ID
Dimension2 = Date
Expression = if(concat(Date,',',Date)<>'','Yes','No')
Then drag Date Dimension to the upper right until you see a blue horizontal line
Output:
Pivot Table:
Dimension1 = ID
Dimension2 = Date
Expression = if(concat(Date,',',Date)<>'','Yes','No')
Then drag Date Dimension to the upper right until you see a blue horizontal line
Output:
See the attached qvw.
another possible pivot table expression:
If(Count(ID),'Yes','No')
hope this helps
regards
Marco
Another solution may be like Add pivot with
Dim:
Id
Date
Expr:
= If(Count(ID) = 1, 'Yes', 'No')
Haha. Almost sneaked your thought process. 😉
indeed