parameter calculated field

S

Sates

i have time dimension. Its level year-month.
I show current year's month on column
script code:
DataAxis.InsertTotal(Totals("Sales"));
DataAxis.Totals("Sales").NumberFormat = "#,##0"
ColumnAxis.InsertFieldSet(FieldSets("TimeDimension"));
ColumnAxis.FieldSets("TimeDimension").Fields("Year").Expanded = true;
ColumnAxis.FieldSets("TimeDimension").Fields("Year").IncludedMembers =
"2005";

i want to show previous year sales another column like this
January February March April
May
2005 2004 2005 2004 2005 2004 2005 2004 2005 2004
745 900 800 700 600 545 754 845 457
454

is tehere any wat to do this.
i was thinking of using calculated field but i could just show total
previous year sales on calculated field.
([measures].[Sales], [TimeDimension].[All].[2004])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated field question 2
Creating a Calculated Field in a Pivot Table for same field 3
Calculated Fields on a Report giving me "#error" 2
Calculated Field 2
DateAdd in calculated field 3
Calculated field won't work... 3
Calculated Field in Pivot Table 1
Create a calculated date in a field on input form 4

Top