Relative display in Pivot

[dafnis14]

Hi,

I Have created a pivot table with 4 dimensions.

The relative expression is :

sum( [# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

when selecting a value for the first dimension, relative results work fine:

When all dimension values are displayed, the relative does not accumulate to 100%:

Any idea how i should fix this?

Thanks!

[Chanty4u]

will u able to share sample app/

or

• Just un-tick relative for all expressions
• Check the number format to be as per your requirement.

[ahammadshafi]

May be this will work

sum( <[Location]>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

Ahammad Shafi

[avinashelite · Accepted solution]

Try like this

sum( [# of Seats/Rooms])/Sum( TOTAL <Location,[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

[dafnis14]

Hi,

Thanks, but there seems to be a syntax issue....

[dafnis14]

Hi,

I tried it, but it doesn't change the result...

Thanks!

[dafnis14]

Hi,

It's a pivot table, so Relative option is not available...

Thanks!

[ecolomer]

Try this:

sum( <[Location]=>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])

[dafnis14]

Sorry Avinash,

I picked the wrong field..

You were right..

Thanks!

[avinashelite]

Cool