I am trying to get point to point values in a straight table when the dimension is set to Quarter. I do not want to aggregate the values for all three months in each quarter. Instead, I want to display the value from the last month in each quarter. My dimension is Quarter_Year so If I have 2014 - 2015 chosen the table will display 8 columns. I have tried to use Max() but then it will only give me the metric for the selected period, not for each Quarter-Year selected. Thanks in advance!
I'm not sure that would work with my case. I cannot change the dimensions because they are conditional based on a selection from a listbox.
The straight table has twenty metrics based on the Values field. My issue is that some metrics require sums across Quarter and some require Point to Point, The sums are easy, but I'm having issues with the point to point. So I don't think I can sort, due to multiple metrics in Values and I cannot change the dimensions,