cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation of variable with where condition does not work

heikeff
Member
0 Kudos

Hallo,

I have a calculation request and rebuilt th eissue with the efashion universe.

I created a report with Category, State and Week and limited the week to 1-5

The requirement here is the following:

In how many states there are more than 20 categories is 5 weeks? In this example the correct number shoud be 3 , as California, New York and Texas have in each of the 5 weeks more than 20 categories => HOW to get that ??

2023-11-23-screenshot-of-the-report.png

Already the filters on the 2 variables I created do not show up all the value shown in the table.

2023-11-23-filter-1.png2023-11-23-filter-2.png

Any advice how to solve that would be appriciated

Accepted Solutions (0)

Answers (0)