Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using a Pivot table and using Partial Sum options for Totals. For column 2 it is coming perfect but for column 1 it is not coming and just showing '-' and then I replaced that '-' with '0' but still the Total is not coming.
Can anyone help me out with this problem?
PS : I have attached the Image for that chart.
Thanks!!!
- Yojas
Hi Yojas,
Use NumSum() instead of Sum()
Regards,
Sokkorn
Hi,
When you try to add values to null() it will result in giving null() values.
Try using if(isnull(exp1),0,exp1).
HTH
-Shruti
Hi
You are probably using a field directly in the expression. This evaluates correctly in the rows, because there is only one possible value for that field for any value of the dimension; but there are multiple possible values at the partial total level, so the partial total expression cannot be evaluated. For the partial total to evaluate, use an aggregation function such as Max(), Avg(), Sum() etc.
HTH
Jonathan
enclosed your expression with sum
sum(your condition)
hope it helps
hi
try
sum(F)
*************
sum(M)
*********************************
or try this
sum( Total F)
*************
sum(Total M)
Hi,
I tried few of those things but still it was not showing the result.
My expression was :
if(citizenship_StdPersonalInfo='Singapore' or isPR_StdPersonalInfo=1, Count({<citizenship_StdPersonalInfo=>}DISTINCT(stdApplicationNo)),0)
And I changed this expression to :
Count({<citizenship_StdPersonalInfo={'Singapore'}> +<isPR_StdPersonalInfo={1}>}DISTINCT(stdApplicationNo))
And I got my output...
But thanks a lot for your inputs
Cheers!!
-Yojas
Hi,
But currently I am showing my total on the top row but I want to show it on the right side of the table means I want horizontal total..
Is there any way to do this in Pivot table??
-Yojas
I have attached a Table image which I was trying to explain for showing horizontal Totals on extreme right of table.
Thanks...
-Yojas
click on total column and drag it to horizontal side after last dimension or
another method is
you can use expression here write Column(1)+Column(2)
hope it helps