Pivot Table Expansion

[gautik92]

I am using a pivot table and in that am using dimesions that are from inline load

if i collapse the dimesion the chart isnt showing any values

any ideas to solve this problem?

[bindu_apte]

Hi,

Can you share sample qvw or the screenshot.

[PrashantSangle]

Hi,

are you using naked expression???

try your expression with sum()

like sum(YourExpression)

Regards

[gautik92]

first table without collapsing

second table after collapsing

[jonathandienst]

Collapsing the dimension causes QV to use a total value (assuming you allowed partial totals). If you have the total as a line from you dimension, then this will be collapsed with the dimension.

If you need to be able to collapse a complex dimension, you will need a dimension one level above to collapse into.You can else create this in an inline. The Pick expression might need to take both dimensions into account.

[jonathandienst]

>>second table after collapsing -- It looks like you have not enabled partial totals.

[gautik92]

I have enabled partial sums still it is not showing partial sum

[pho3nix90]

Please upload your qvw, or at least your expression.

This sounds like an expression error.  Or you are using a calculated dim?

[jonathandienst]

Lets see the definition of the inline dimension and the table expressions -- or better still, your qvw document or a representative sample (if its too large or you share the real numbers).

Preparing examples for Upload - Reduction and Data Scrambling

[gautik92]

Hi jontydkpi

Now collapse is working i tried with pick function but still am not getting partial sums

it is showing null