Sum above values only when a dimension value is equal to the current one

[Anonymous]

Hi guys, I can't figure out how to sum above rows only when the rows have a field value equal to the current one.

Two dimensions: CAR and COLOR

Value QUANTITY

Let's see the source table:

I'd like sum for eache row above quantity + current quantity only when color equals to the current one.is what I expect to obtain.

How can I obtain it with formulas ?

thank you

[datanibbler]

Hi martinovedana,

aggregate: Insert a sum([Quantity]) function in your LOAD.

=> Keep in mind you then need a GROUP BY clause encompassing ALL OTHER fields present in your LOAD.

HTH

Best regards,

DataNibbler

[Anonymous]

thanks DataNibbler but I can't do it during LOAD because it has to be dynamic based on current selections

[datanibbler]

Hi,

well, on the GUI, you could use a set_expression to sum up all the items grouped by (the user's current selection) which you can query using GETFIELDSELECTIONS().