Cannot Create a Pivot Table Object

[#1]

Hi Forum, I am trying to create a Pivot Table Object and i am getting only the fist Dimension and nothing else. I compared it with another Pivot Table that i've created and they look the Same works and the othme except that one works and the other one doesn't. Any Ideas?

[nilesh_gangurde]

Hi mroman,

Confirm that u have added the dimensions, expressions in the Chart.

Or attach the qvw file.

Regards,

Nilesh Gangurde

[#3]

what expression are you using?

[#4]

I am using Adventure Works DW database.I'll attach the QVW file.

Manuel

[#5]

Sum(Extended Amount).  I am using 2 dimensions and the amount.

[#6]

did you get any errors reloading the QVW?

[#7]

no, no errors. i can create a table and works fine

[mphekin12]

Go to the Presentation tab of the Chart Properties, uncheck Suppress Zero-Values.  All of your Sales Territory Groups will be displayed, but the sum of the Extended Amount for these territories are all $0.00.  You might want to try to remove some of the synthetic keys in your data model.  That might be the reason why the Extended Amounts are showing up as $0.00.

I hope this helps.

[#9]

Thanks,i now know what i am doing wrong.... thanks for the help.