display expression as a dimension in a pivot

[lmonincx]

Hi,

I am trying to establish that i can show a sum(Budget) as one value acting as a dimension in a pivot is this possible? I don't want it as a measure as i only want it listed once and not displayed for every month on top .

Month

Jan 09 Feb 09

Product sum(Budget)

A 200 160 40

Is this possible?

Thanks for any help!

Regards, Linda

[#2]

Hi Linda,

I dont think you need to have it as a dimension to display data in this fashion. All you need to do is tweak the pivot a little as done in attached example. Let me know if this solves your problem.

Thanks

Amit

[lmonincx]

Hi Amit,

Thanks that works , is it also possible to change the name of the label, now the expression is shown as label?

Regards, Linda

[lmonincx]

oops no this still doesn't work, its still summing the expression (actuals) and i would like to sum on a different measure ' budget' I would like total on a different measure than used in the expression.

[#5 · Accepted solution]

Well in that case it could be solved by adding the Budget as a dimension. Please see the attached file how it could be implemented.

Thanks

Amit

[lmonincx]

Thanks that will do!

Linda

[rajni_batra]

in the table i have added so may expressions but want them as dimension so that user could select any of them from their hoice is their any way to do that. i did mention only a few expressions but a lot to implement..

thnks n regards........