Forum Discussion
Pivot
Hi I am getting a issue where by my totals are not adding up correctly I have a pivot table the column subtotals are brining back in incorrect figure. it seems to be the column subtotal is ...
still hard to see exactly, but what if you wrap your function like:
SUMX(
VALUES( table [col] that is on rows),
[Measure]
)
Hi,
Im still getting the same result.
I have a electric board that has 20 sockets, I need to work out the energy used within each hour period per socket. Individually for each socket the MAX - (minus) - MIN energy that I created works correctly. When I use MAX - MIN as a total of all sockets its basically bringing back a figure of 516 rather than 27.9. In my raw data there are instances where energy MIN is 0 and MAX 516.
in my pivot table the individual socket readings are correct but total is not the sum of all readings
for e.g.
1 2 3 4 5 6
0.12 0.0 0.03 0.14 0.00 0.07 = 0.36, however what Im seeing is 516