Hi Kenshin,
1. Insert a Crosstab.
2. Use the Month formula as the Row and the measure field as the "Summarized Field".
3. Highlight the Month formula in the crosstab's row > Group Options > Options tab > Check "Customize Group Name Field" > Click "Use a formula Group Name" and press the formula button beside it.
4. Use this code in the formula:
Mid({@Formula_Name}, 3)
5. Save and close the formula and click OK.
6. Right-click the Crosstab > Select Insert Chart > Choose the Chart Type you need.
7. Suppress the section that holds the Crosstab.
-Abhilash
Add comment