How do I show pivot results above a certain value ?

[#1]

Hi Everyone.

I have a pivot table object on my dashboard which shows the sum of budget amount per customer. I want to restrict the list to those customers whose total budgets are greater than £20,000. How do I do this in set analysis ?

Thanks for your help

MV 

[ali_hijazi]

if your expression is sum(Budget)

then it will be something like this

sum({<Customer={"=sum(Budget)>20000"}>}Budget)

[anbu1984]

If(Aggr(Sum(BudgetAmt),Customer)> 20000,Sum(BudgetAmt))

[#4]

Hi Anbu,

What's the advantage of using AGGR in the expression, rather than not using it ?

MV

[anbu1984]

From QV help,

aggr ([ distinct | nodistinct ] [{set_expression}]expression {, dimension})

Using Aggr() you can do aggregation for the dimensions mentioned in Aggr(), instead of all the dimensions included in your chart.

[simenkg]

sum({<Customer={"=sum(BudgetAmount)>20000"}>}BudgetAmount)

[sujeetsingh]

Use calculated Diemsion

[#8]

Hi Ali,

How do I include a second condition into your expression ?

Type = "Budget"

MV

[anbu1984 · Accepted solution]

sum({<Customer={"=sum(Budget)>20000"},Type={'Budget'}>}Budget)

[ali_hijazi]

Maureen Vickers anbu cheliyan already answered you