I have a crosstable with a group made up of a field that contains dates.
The report can have 3 - 4 - 5 columns depending on the selected customer.
I want a calculated member for each date that I give a percentage between two fields that I have identified.
My problem is that if I add a calculated member it makes me just for the column from where I started.
But I want a dynamic column for each client regardless of the date I selected.
is it possible?
I tried using the expert calculated member but as the column of type date I will not allow me to perform calculations on fields that I am.