If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

cognos dimensional reporting count

Started by cognos05, 12 Jun 2017 02:33:40 PM

Previous topic - Next topic

cognos05

I have a report based on 5 product category analysis, p1 to p5

I have a calculation which would do the Account count for
All 5    4 of 5   3 of 5   2 of 5   1 of 5   0 of 5

Meaning it should say out of these 5 product categories , if there were 2 categories which had a sales greater than 0 for a specific agency  then this will be counted as 1 under 2 of 5 , if its 3 then its counted under 3 of 5 .

I am not sure how to do the calculations for 1 of 5, 2 0f 5, 3 0f 5 and 4 of 5 .

I can have 5 count variables for each product category and individually see if the they have sales for each specific product category and get their count if its greater than 0 .
then how would I write my expression for 2 of 5 - meaning out of these 5 count variables if any 2 are greater than 0 then it will count 1 to 2 of 5 .
2 of 5 expression  - to check if any 2 varaiable out of 5 has a greater value

Any help is appreciated .

Thanks,



cognos05

Hi Guys,

Any suggestions on this is appreciated.

CountP1 CountP2 CountP3 CountP4 CountP5

All these values are calculated . Now how to calculate 1 0f5 ,2 of5 , 3 of 5 and 40f 5 based on this count

Basically if countP1 has value >0 then sum1 , similarly check for all 5 varaiables and based on sum value we will put in 1 0f 5 or 2 of 5 buckets.