i wanna create bar chart

[#1]

• ž X-Axis  -- Month (Past 13 Month)
• ž Y-Axis  - MoneySpend comparison for month over month (Comparing same month of last year with same month of current year)

please tell me how to achieve this

[sushil353]

Hi,

For better solution..

you can post you sample data here...

for your solution. you can add month as dimension and in dimension list you can restrict them for latest 13 month.

and in expression you can create 2 expression..

sum({<Year = {'$(=Max(Year)-1)'}>}Sales) ---  for previous year sales.

sum({<Year = {'$(=Max(Year))'}>}Sales) -- for current year sales.

HTH

sushil

[#3]

Hi,

add month as dimension and > goto dimension limits > put latest 13> write above 2 expression what sushil provided