Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My QV Table , display total sum wrong. How to make it correct ?
I will post my QV Doc in my next post.
Paul
Hi Paul,
If you are using Straight table then choose some of rows in Expression tab for the expression.
Regards,
jagan.
Hi,
try
sum(aggr(sum(YourExpre),dim1,dim2..))
Regards
Paul,
if you can't post a .qvw, post a screenshot of your table to try to help you in the best way.
S.
Hi Paul,
There is no suficcient information for us to help you. Can you please describe your issue better?
Regards,
MB
Paul,
Try this:
Thanks,
AS
may be anything wrong in your expression??
Hi Paul,
Since you are using Pivot table, Sum of Rows option is not available. To get the correct value try like below
=Sum(Aggr(Sum(MeasureName), Dimension1, Dimension2., ......DimensionN))
Note: In above expression replace MeasureName and Dimension1, Dimension2., ......DimensionN with your actual fields.
Hope this helps you.
Regards,
Jagan.