Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try like this
sum( [# of Seats/Rooms])/Sum( TOTAL <Location,[ServDay of week], RsvServiceDate > [# of Seats/Rooms])
will u able to share sample app/
or
May be this will work
sum( <[Location]>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])
Ahammad Shafi
Try like this
sum( [# of Seats/Rooms])/Sum( TOTAL <Location,[ServDay of week], RsvServiceDate > [# of Seats/Rooms])
Hi,
Thanks, but there seems to be a syntax issue....
Hi,
I tried it, but it doesn't change the result...
Thanks!
Hi,
It's a pivot table, so Relative option is not available...
Thanks!
Try this:
sum( <[Location]=>[# of Seats/Rooms])/Sum( TOTAL <[ServDay of week], RsvServiceDate > [# of Seats/Rooms])
Sorry Avinash,
I picked the wrong field..
You were right..
Thanks!
Cool