How to do set analysis, conditioned on variables?

[DSDD]

Dear Community,

i want simply to count(ORDERS) omitting the second group/dimension, where both dimensions are conditioned on the users selection by variables.

 count(TOTAL <MONTH>ORDERS) will do normally, BUT

both dimensions are conditioned on variables.

That means the first Dimension may change between DAY, WEEK and MONTH

and the second between CAT1 and CAT2 (having different categories).

The count(ORDERS) works and gives the number for the group.

Now i want the Order-Count of each MONTH (WEEK/DAY) omitting the CAT1-Subset (CAT2-Subset), resulting of course in the same number in each category for a MONTH (WEEK/DAY) .

I have no idea what the syntax may look like, tried several non working.

Thank you in advance

[MayilVahanan]

HI @DSDD 

Try like below

count(TOTAL <$(vfirstDimensionVariableName)>ORDERS) 

Hope vfirstDimensionVariableName contains value similar to ur dimension (MONTH (WEEK/DAY))

[DSDD]

Dear Mayil,

for some reason in this case, where the  groups (lets say: region and salesman) are a variable too, the code you mentioned is not working.

The TOTAL in this caes takes the count of all ORDERS irrespective any selection, irrespective $(vfirstDimensionVariableName)>. I think the reason is that the dimension for  bars is a variable (with the fields region and salesman). If i explicity state region in this dimension, than it works.

Do you have any idea, why its not working with a variable?