columns with percentage values in pivot tables

[Anonymous]

Hi all,

when working with pivot tables,I often liked to add some some columns with percentage values.

For example, now I have this:

but I would like to have something like this:

Does anyone knows if is it possible?

Thank you!

Sofia Vaz

[ychaitanya]

Can you elaborate the problem here.

Have you tried adding the expression for %?

[shiveshsingh]

Please share ur app and data, it's possible i think.

[Anonymous]

sum(dimension) / sum(total dimension)

Mark the dimesion wtih Show Partial Sums in the  Presentation!

[Anonymous]

Thank you Shivesh. I'm not able to share app or data...

[Anonymous]

Thank you Antonio.

I've add the % expression as a measure. Do you know if there's a way to present the results only for the Total lines? I don't need to present them to for all the cases, as it is now...

As it is now:

As I would like it to be:

Thank you!

[Anonymous]

Hi Chaitanya.

I've add the % expression as a measure. Do you know if there's a way to present the results only for the Total lines? I don't need to present them to for all the cases, as it is now...

As it is now:

As I would like it to be:

Thank you!

[olivierrobin]

hello

try to use dimensionality()

something like that in your column

if(dimensionality()=1,sum(...),'')

[Anonymous]

Hi Olivier,

I'd never used dimensionality() before, so I may not understanding this very well.. What I've tried was to change the % expression to this:

if(Dimensionality()=1,(sum({<OrdMasterOrdDateYear={"$(=vYearToday)"},OrdMasterOrdDateWeekYear={$(=vLastOrdMasterOrdDateWeekYear)},OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={*}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'}, OrdItemOrdStat={'CONFIRM','COMPLETE','HOLD'}>}if(OrdItemDelDate<>OrdMasterOrdDate, OrdItemOrdKgs))/1000)/(sum(TOTAL{<OrdMasterOrdDateYear={"$(=vYearToday)"},OrdMasterOrdDateWeekYear={$(=vLastOrdMasterOrdDateWeekYear)},OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={*}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'}, OrdItemOrdStat={'CONFIRM','COMPLETE','HOLD'}>}if(OrdItemDelDate<>OrdMasterOrdDate, OrdItemOrdKgs))/1000

),"")

but the output is this, not exactly what I wanted:

[olivierrobin]

oups  !!! sorry

use secondarydimensionality()

it works the same way but on columns