Pivot Table

[Anonymous]

good afternoon

They could help??

Can you use an expression as dimension in a pivot table?

Thank you

[sunny_talwar]

You can, you just need to use either Aggr() function or Total qualifier with it for it to work properly

[Anonymous]

Hi 

Sunny  T

good afternoon

Is there any other way to do it other than the Agrr function

[Anil_Babu_Samineni]

Might be other ways possible, Would you let us know what was the expression you want to as Dimension. So that, We can open other ways too for you that Agenda

[sunny_talwar]

Can you provide a sample to help you better?

[dineshm030]

Can you send the sample QVW file?

[Anonymous]

Hi,

Yes you can add expression as dimension with aggr() function, u will require to aggregate ur expression against some given dimensions.

Thanks,

[Anonymous]

Good afternoon

this is the expression that I need to use as dimension

SUM(PACTADO_INICIAL)

Thank you