Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi mroman,
Confirm that u have added the dimensions, expressions in the Chart.
Or attach the qvw file.
Regards,
Nilesh Gangurde
what expression are you using?
I am using Adventure Works DW database.I'll attach the QVW file.
Manuel
Sum(Extended Amount). I am using 2 dimensions and the amount.
did you get any errors reloading the QVW?
no, no errors. i can create a table and works fine
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.
Thanks,i now know what i am doing wrong.... thanks for the help.