I am trying to created two metrics to use on a report, I am having a problem with one.
There are Stores and Departments, Stores have many departments (Parent>Child)
here is my report
Department Sales StoreSales
------------------------------------------------------
10 100 800
20 100 800
30 100 800
40 100 800
The report has filters that says where department in (10,20,30,40) and date = 12/06/2004
the thing is, the StoreSales metric should be the sum(sales) to the Store level for 12/06/2004 but without the department filter condition.
How to do this?
Thanks,
bitt
There are Stores and Departments, Stores have many departments (Parent>Child)
here is my report
Department Sales StoreSales
------------------------------------------------------
10 100 800
20 100 800
30 100 800
40 100 800
The report has filters that says where department in (10,20,30,40) and date = 12/06/2004
the thing is, the StoreSales metric should be the sum(sales) to the Store level for 12/06/2004 but without the department filter condition.
How to do this?
Thanks,
bitt