We need to show Period Over Period calculation in line chart which has 2 dimensions(Month and Product). We are using Above() function in the line chart and it was displaying wrong numbers in the chart.
Above() function was working fine in the single dimension chart but not in dual dimension chart. Below is the example of expressions using in my chart.
I need to show some of the metrics at month level and some at quarter level. My data consists of both Month start date and Quarter start date. I am able to achieve the functionality for monthly data using AsOf Table. I need to show some data for single dimension and some for multiple dimension, similar to Jaswanth's.
Can the same AsOf Table be used for showing both monthly as well as quarterly, or do we need to separate tables. Itried to modify the existing code a bit for quarterly view but couldn't achieve the desired functionality?
I am attaching my sample data (single metric only) and QVW file.