Total is not displayed in Pivot table

[pipuindia99]

Hi,

I have an issue, I have created a pivot table and partial sum has been checked for the Cost field. I am not getting the total though i have checked partial sum, i am getting only the label for Total and not the values.

appreciate your help in this.

[kkkumar82]

Hi Prabhu,

When you are using Valuelist, you wont get sub totals as per knowledge, faced this issue earlier.

[pipuindia99]

just now realized. is there any other way to solve this issue?

[qliksus]

Is there any Custom Format done in the cell of the sub-total  because it should work considering it is showing values . You can post the Expression you are using

[#5]

Possible to add the valuelist to the data table directly?

[pipuindia99]

Hi,

Are you using Valuelist in expression also?.. or only in dimension?

[qliksus]

Hi ,

I am using it in Expression also

[pipuindia99]

are you using Rand() in expression? or real-time vales

[vinieme12]

You cannot use Partial Sum with ValueList as these are synthetic dimensions,

Load and Inline Table with the fieldvalues and link it to your data table,that's all you need to do

[qliksus]

Hi ,

Below is the sample expression I am using

if( ValueList('Actual','Budget','Forecast')='Actual' , sum(Amt) ,

if( ValueList('Actual','Budget','Forecast')='Budget' , Sum(Amt1) , 

Sum(Amt3)

)

you can use your corresponding expression for Actual,Budget,Forecast