Set Analysis with a variable in the filters (possible?)

[#1]

Dears, I would like to do a set analysis using variables, but the variable would be the filter of the formula, for example:

This is the normal

=Sum({$<PRODUCT_FAMILY={"Family"}>}($(vInvoice))

I want to use the variable in the <  > (in the place of PRODUCT_FAMILY)

How do I do that?

[sudeepkm]

EDIT:

surprising I added the variable inside but it didn't show up

=Sum({$<PRODUCT_FAMILY={"$(vInvoice)"}>}Sales)

=Sum({$<PRODUCT_FAMILY={""}>}Sales)

[#3]

I would like to place the variable vInvoice inside the < >, instead of PRODUCT_FAMILY

but it is not working properly. How do I do that?

[#4]

???

and how would it be using the PRODUCT_FAMILY?

[alexandros17]

Unfortunately no ...

[gmoraleswit]

Declare a variable with the value : PRODUCT_FAMILY={"Family"}

Use it in your expression:

=Sum({$<$(vVar)>}($(vInvoice))

You can also use multiple variables:

=Sum({$<$(vVar),$(vVar2)>}($(vInvoice))

[#7]

Have you tested it?

[gmoraleswit · Accepted solution]

Yes, see attach

[sudeepkm]

I'm sorry I thought you are asking to have a field value taken from a variable.

but please take a look at the example.

I've declared a variable as Field name and used that in set analysis. I thought it would not work.