Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been trying to put together a set analysis in a filter and got it to work on the basic level. i.e.
=[Shirt Orders]<=720 or
=[Shirt Orders]>1000
and the output in the filter drop down is -1 and 0 that is fine.
When I add more than or less than the functionality did not work.
=[Shirt Orders]>1000<=1200
I also tried
Count({<[Shirt Orders] = {">$(1000)<=$(1200)"}>} [Shirt Orders])
but it did not work.
Any help is appreciated.
Kurleigh
You would need to use Aggr() function.... May be like this
Aggr(
If(Count({$<[Shirts]={"blue"},[shirt orders]={"<=700"}>}[shirt orders]), 'Blue Shirt orders Less than 700',
If(Count({$<[Shirts]={"red"},[shirt orders]={">200"}>}[shirt orders]), 'Red shirt order above 200', 'All other Shirts')), Shirts)
Aggr(
If(Count({$<[Shirts]={"blue"},[shirt orders]={"<=700"}>}[shirt orders]), 'Blue Shirt orders Less than 700',
If(Count({$<[Shirts]={"blue"},[shirt orders]={">700<=1440"}>}[shirt orders]), 'between 700 and 1440', 'All other Shirts')), Shirts)
Even though I said only count those <=700 it still counted all the shirts in the first bucket and the second and third was not created.
How about trying this
Aggr(
If([Shirts] = 'blue' and [shirt orders] <= 700, 'Blue Shirt orders Less than 700',
If([Shirts] = 'blue' and [shirt orders] > 700 and [shirt orders] <= 1440, 'between 700 and 1440', 'All other Shirts')), Shirts)
Or just this
If([Shirts] = 'blue' and [shirt orders] <= 700, 'Blue Shirt orders Less than 700',
If([Shirts] = 'blue' and [shirt orders] > 700 and [shirt orders] <= 1440, 'between 700 and 1440', 'All other Shirts'))
Woot Woot.
Thanks man it worked!!
Awesome