Iam having a scenario where I need to count the total number of Invoices raised at calweek level for different outlets.
Say for example a salesman raises 2 invoices at an outlet A in a week and 5 for another outlet B in the same week.
Then the report will look like
Outlet No of bills raised
My cube has Outlet,Invoice number and 0calweek. I need to check the total number of Invoices / bills raised.
I think adding a counter in the cube will help. Is this correct way of doing?If so how do I populate the counter field?
I tried creating a structure in Bex..But without a keyfigure the structure and formula to count the rows in this structure doesn't work.