%'s in Pivot Table

[wgonzalez]

I'm using a pivot table to group costs by two dimensions. 

Situation:

- When dimensions are expanded %'s are calculated correctly.

- When dimensions are contracted %'s are incorrect.  QV is summing %'s instead of calculating them at total level.

Any idea of how can this be fixed?

This is the Expression calculation:

sum({<WO_State={'Closed'}>}[Cost of Scrap]/VOP)

As you can see, I'm using a Set Modifier.

[Jason_Michaelides]

Try:

sum({<WO_State={'Closed'}>}[Cost of Scrap]) / sum({<WO_State={'Closed'}>}VOP)

Hope this helps,

Jason

[wgonzalez]

Hi Jason,

I've alread tried that, but results are blank.  No information at all.

[Jason_Michaelides]

Can you post a sample app?

Not sure this will give the right result, but try:

sum({<WO_State={'Closed'}>} TOTAL [Cost of Scrap]/VOP)

[wgonzalez]

Weird thing, this is what worked good:

[Cost of Scrap] / VOP

No set modifier, no SUM function.  It's weird since I wanted to restrict the data set to those whos value in field "WO_State" is "Closed".  The set modifier works fine for other calculations or fields in the same pivot.  Only for %'s need to be taken out.

Any comments?

[Jason_Michaelides]

Can you post your app?