Client is created Ad-hoc query with total value. The total value of values is showing adding with zero for Ex the actual total value is $2225 but in Ad-hoc query result the total value is showing $22250. So I have checked the cube. The total value is showing correct I mean $2225Please help me to show the original value in the query.
Thanks in Advance