RangeSum at 2 Dimensions Chart

[#1]

Hi,

I had problem creating bar chart.

The "Chart-A" with setting:

• Dimensions: YEAR, MONTH
• Expressions: =RangeSum(ABOVE(SUM(YIELD),0,RowNo())) / MONTH * 12
  

The "Chart-B" with setting:

• Dimensions: MONTH, YEAR
• Expressions: =RangeSum(ABOVE(SUM(YIELD),0,RowNo())) / MONTH * 12

Why the both showing different chart and figure as the table data are the same.

Can anyone help.

Thanks

[Chanty4u]

chk dis

Missing Manual - Above() and Below()

[Gysbert_Wassenaar]

They are different because the order of the dimensions is different. The first groups the years per month, the other the months per year.