Lock pivot table dimension column

[#1]

I have a pivot table in QV11 with one dimension (date), which is across the top, and about 30 expressions. i would like to keep the first column showing the last day of the previous year, and possibly a few others for month-ends. i would also like to have another column that will change with a date selection. anybody know the best way to pull this off?

          12/31/2011(fixed)           9/19/2012 (changes with selection)

exp1

exp2

exp3

exp4

exp5

...

i should also add that the date is loaded from a table and the expressions are made up of set analysis on info from a table.

[Anonymous]

Looks like it can be done by using calculated dimension for Date using set analysis, so that it will show selected Dates plus some "hard-coded" in the set expression.

See help on set analysis, there are examples how to do this.

Regards,

Michael

[#3]

thanks Michael. i was having some trouble finding the right function to use with the set analysis. I appreciate the help though.

[Anonymous]

This solution works for me:

1. Calculated expression for Date:
=aggr(only({<Date+={'12/31/2011'}>} Date),Date)

2: Condition in chart expression to ignore Date selection (in each expression if there are many):
=sum({Date=} field)

Regards,
Michael

[#5]

Thanks Michael.