I need to have a report where i am adding a date value in the measure so that my first heading will be weekwise.
Below is a sample of the result needed
Assigned | Pending | WIP |Grand Total
p1|p2|p3 p1|p2|p3 p1|p2|p3 p1|p2|p3
In column i am putting the date feild,then the priority,This grand total is a calculated column which i am adding in the measure.
My requirement is that i do not want to show the individual priorities in the grand total.It should only show the sum of the values in Assigned,Pending,WIP.
I am not able to achieve this.Can you please help in this regard.