Hi everyone,
I have a problem with see all the "useful days" of a month, in a PivotTable.
Example:
The variable "t_day_month_year", shows the days of operations of my company;
The variable "num_operations", shows the number of operations in that date;
Tha variable "values", shows the value of the operation;
And I have an expressions:
- to get the sum(values), in my case, per day;
But, when the month have one day without operations, obviously, that variable don't have the value of that day.
Example:
Date NºOperations sum(Values)
30/07/13 2 15000
31/07/13 5 20000
02/08/13 1 4000
The problem is: in the date 01/08/13, my company did't do any operations. But, that date is a "useful day", I have to show this date like:
Date NºOperations sum(Values)
01/08/13 0 0
How can I do that? In script, doing some inline table? Or something like this?
Mark to show "all values" of dimension, doesn't work, because this date don't exist in the field in database.
Thank you!
