How to load multi dimension cross table into QV?

[wendytham]

Hi. How to load this data into QV? Please assist. Thank you.

[sunny_talwar]

What will be the dimension for the chart you are going to be using this expression in?

[wendytham]

Hi Sunny,

Dimension will be Month (in MMM format).

If the Financial Year period is as below, and I would like to select the year by Financial Year, how to set it?

04/2016 to 03/2017 = FY2016

04/2017 to 03/2016 = FY2017

Thank you.

[sunny_talwar]

You can check here for Fiscal and Standard Calendar generation

[wendytham]

Ok, thanks. How about the market ratio formula?

[sunny_talwar]

I wonder how you will use RangeSum(Above()) if Month is the only dimension... are you sure you mean Month or do you mean MonthYear (a field which has both month and year)?

[wendytham]

Sorry, i meant MonthYear. The market ratio (in%) need to plot in line graph. TQ.

[sunny_talwar]

Then I think the expression looks good to me....

[wendytham]

But I wish to create a variable in script for this market ratio as I need to drill down the market ratio for all the Model# which is not show in the attached data.

[wendytham]

Do you mind to share the qvw file?

[sunny_talwar]

Share qvw file? Which qvw?