Pivot Table Help

[satishkurra]

Hi

I have below problem.

Business wants to display this report of total on row wise.

I'm getting 100 % on column wise.

Is there any way

Dimensions: Type and Week Starting Date

Measure: Sum(Hours)

Please help if we can achieve this in QV

[krishnacbe · Accepted solution]

Hi,

Hope you are using Show Partial sum for Week Starting Date. Uncheck it and enable the Show Partial Sum check box for type. you will get the expected output.

[sergio0592]

Create pivot chart and as expression:

  =num(sum(Hours)/Sum(TOTAL <Week Starting Date> Hours) ,'#,#0%')