Grouping In OBIEE

Question

Hello All,

I have a requirement they want to see count of the columns.I am facing a issue to do it. Can anyone let me know how to do this requirement.

Sample Data:-

Status 2015Status 2016Status 2017Service PartSerial PartTBDService PartSerial PartTBDService PartSerial PartService PartService PartSerial PartSerial PartTBDService PartSerial Part

Note :-Data above is conditional data and there is no unique column i can group by

Expected Data:-

Status 2015Status 2016Status 2017

Service Part411Serial Part042TBD100

Let me know your thoughts

Thanks

Uday

3184221 · Answer

Thanks Its is working

ArijitC · Answer

In column formula add something like Count("Column Name" by "Column Name")  and also add the column. Then use pivot table. Example...