how to categorized sales by total area wise

[venkat1]

Hi friends,

I have a list box selectors of area-wise and branch wise and a pivot table with the sum of a.sales and b.sales 

now my requirement is to create a list box with L.V, M.V, H.V selectors (where.., L.V is sum(a.sales&b.sales)<=100 , M.V  = sum(a,sales&b.sales)<=500, H.V is (a.sales&b.sales)>500.

help me out with this .

[asinha1991]

if you will select only one value from LV HV andMV then this will work, if you want multiple then include all permutation and combination

Load * inline[

_field

LV

MV

HV

]

make list box with _field

in pivot expression use something like this.

If(getFieldSelections(_field)='LV', if(sum(asales)+sum(bsales)<=100, sum(asales)+sum(bsales),If(getFieldSelections(_field)='MV', if(sum(asales)+sum(bsales)<=500, sum(asales)+sum(bsales),If(getFieldSelections(_field)='HV', if(sum(asales)+sum(bsales)>500, sum(asales)+sum(bsales))))

check syntax

hide null values one expression