Table design

[Anonymous]

Hi all,

How i can design a table in the report, like:

Year	Month	Sales
2010	2010.05	100
	2010.06	200
	2010.09	123
	2010.11	444
2011	2011.01	222
	2011.05	111
	2011.11	100
2012	2012.02	200
	2012.03	300
	2012.04	300

[#2 · Accepted solution]

Use this

if(Above(Total Year) = Year, ' " ', Year)

This will work in Expression, not in dimension. Straight table, hide dimension column.

HTH

Shubhu

[#3]

Use pivot table and add dimension Year, Month, Sales field.

In presentation tab uncheck "Supress zero values".

I hope this helps you.

Regards

Venkat

[#4]

Hi,

In pivot table

Add Dimensions - Year and Month,

Expression - sum (sales)

Regards,

P.Prasath