
Re: i want to divide the category (sum(sales)) to A, B, C, D category
Sunny Talwar Mar 4, 2016 10:25 AM (in response to balu k)Have you tried adding 'Category type' as your dimension?

Re: i want to divide the category (sum(sales)) to A, B, C, D category
balu k Mar 4, 2016 10:27 AM (in response to Sunny Talwar )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
balu k Mar 4, 2016 10:31 AM (in response to balu k)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
Sunny Talwar Mar 4, 2016 10:55 AM (in response to balu k)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
Marcus Sommer Mar 4, 2016 11:51 AM (in response to balu k)This was you want is called a Calculated Dimensions and you need to wrap your expression into an aggrfunction 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 ProductCategory  best is to see within the link above.
 Marcus

Re: i want to divide the category (sum(sales)) to A, B, C, D category
balu k Mar 4, 2016 2:17 PM (in response to Marcus Sommer )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
Marcus Sommer Mar 4, 2016 3:23 PM (in response to Marcus Sommer )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
balu k Mar 8, 2016 9:58 AM (in response to balu k)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
Marcus Sommer Mar 8, 2016 11:00 AM (in response to balu k)Are there any section access implemented (which might restrict the data)?
 Marcus
