10 Replies Latest reply: Mar 8, 2016 11:00 AM by Marcus Sommer

# i want to divide the category (sum(sales)) to A, B, C, D category

I Have sum(sales) like this then i want to divide the category in straight table using express Category type is A,B,C,D. can you please share me how can to resolve this

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

No there is no dimension of category type i want to divide based on expression

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

Do you look for something like this: Recipe for an ABC Analysis?

- Marcus

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

If(Sum(Sales)/1000)>=100,'A',

If(Sum(Sales)/1000)>=50,'B',

If(Sum(Sales)/1000)>=10,'C','D'

like this i want but its not working

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

Do you have a sample data you can provide with your expected output?

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

This was you want is called a Calculated Dimensions and you need to wrap your expression into an aggr-function like this one:

aggr(

If(Sum(Sales)/1000)>=100,'A',

If(Sum(Sales)/1000)>=50,'B',

If(Sum(Sales)/1000)>=10,'C','D'))),

YourDimensions)

YourDimensions meant something like Customer and/or a Product-Category - best is to see within the link above.

- Marcus

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

ok thank you and this divided category whatever divided then this i want to shown into multibox is it possible?

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

Yes, you could use these expression within a list- or a multibox.

- Marcus

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

Thank You so much Marcus.

and i have other question want to ask you in my qvw i have data but it does not shows data in access point.

Error:   No data display in Qvw  in Accesspoint. I tried to remove last document state after again check but its not showing  any data now also. Please need a help.

• ###### Re: i want to divide the category (sum(sales)) to A, B, C, D category

Are there any section access implemented (which might restrict the data)?

- Marcus