How to aggregate data filtered by a column including the values of another based on a selection?

VolkanKu — Tue, 01 Dec 2020 10:47:25 GMT

Hello,

I have a formula like below and it worked until i needed another filter for my analysis.

sum({<[B]={1}>} [C])

The data is formed by joining tables and the simplified end result is something like this;

What i am trying, and failing, to do is getting the sum of all C while B = 1 and any A row when D is selected.

IF "C010-013" at D is selected then the rows to calculate would be;

And the sum result would be;

It would be best if there is a way to get this result without changing the LOAD script for the data table.

Re: How to aggregate data filtered by a column including the values of another based on a selection?

VolkanKu — Thu, 03 Dec 2020 05:14:42 GMT

Anyone? 😱

Vegar — Thu, 03 Dec 2020 05:55:47 GMT

Try to solve this using P() in your set. Something like this.

sum({<[B]={"1"}, [A] =P({<[D] ='$(=only([D] )) '>} ) >} [C])

VolkanKu — Thu, 03 Dec 2020 06:34:46 GMT

Hello,

Thanks for the reply but unfortunately i am getting "The selection generated no data for this chart" whether i select any D or not.