Hi,
In a recent video like for like same period last year measures were created;
so if current year only has 6 month the total for prevous year should aslo just have those months
this was ;
But I also tried the following which does give ( i think) the correct start and end dates but for the total I only get the last figure, I have highlighted this in the Pivot attached;![]()
Please Login or Register to view this content.
Can someone see why I'm getting the wrong result, secondly is there a way apart form the 'IF' statement I've use to get ride of the unwanted figures![]()
Please Login or Register to view this content.
I have highlighted these in orange, can someone tell me how they are calculated;
Richard.
Richard.
Bookmarks