pivot table help

[#1]

hi

I am trying to achieve the pivot tablet to be calucalted properly but I could not

kindly help me out in exact solution.

[marcus_sommer]

More isn't possible ...

- Marcus

[#3]

Marcus

Thanks for your efforts

same i am applying at my end but i coulnot get the result as u get.

[marcus_sommer]

I meant disable the option, drag the column-width and enable the option again. If it don't work change web-view to normal-view, drag the column-width and change to webview.

- Marcus

[#5]

Thanks Marcus

i really excited with your aproach

really impressed with you Marcus

Thanks again

one more small confusion how to rename the calc column in our pivot table?

[marcus_sommer]

You meant for the dimension Type the value calc? Then: if(Type = 'Calc', 'RenameValue', Calc) as calculated dimension or directly within the script. For dimensions/expressions themself you could use the label-option in the properties.

- Marcus

[#7]

HI Marcus

thanks for your suggestion

my requirement is previously it was calc now it should get replaced wth Actual % , but unfortuately i am not gettng the expression if i used actual % there help me out

[#8]

Marcus,

i was deeply confused now the way the chart was created intially

i start creating a new qvw with the same dimensions and same expression bbut my chart looks like this

but the original one was

and also while creating a new qvw i need " Actual %" instead of Calc even that is not getting for me

kindly help me out

[#9]

Marcus,

Marcus i need your help on how to rename the coumn "Calc" to "Actuals%". As you said that expression in cal dimension ,  i couldnot get the exact result though. So, can you guide me