chart percentage growth

[sqlpuzzle]

I would like to have the percentage change over months in a Chart.

How can I get this done on the attached document.

Thanks

[sunny_talwar]

May be this

=Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country)/Above(Count({<begindate=,enddate=>} country))-1

[sunny_talwar]

Or this

=Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country)/Above(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country))-1

[sqlpuzzle]

Thanks Sunny for the expression.

The expression seems correct until I add another dimension into the Chart.

Something is happening that I cannot figure out.

Look at the attached qvw.

[sunny_talwar · Accepted solution]

Check the attached