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,
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.