This has to be my output
Customer TBD LM TO
12345 45 20 34
25643 7 8 9
TBD, LM, TO comes from the same column, so I create a Data Item = 'TBD' and how do I count how many TBD's per customer.
Thank you
You could use a crosstab, with your measure either count(<column>) or count(distinct <column>) depending on what your requirement is?
Check below kb on cognos
KB 1033352.2
How to total a measure for members from different dimensions.
Thanks.