I have three attributes:
I have created a pivote table:
I put orderyear and ordermonth in the dimension and the expression is sum(amount).
But i get object shows no data.
I checked the data with a table box.
So where is my mistake?
try with RangeSum(amount)
¿are you sure about the data?
Try with a table object and your tree fields .. if the amount values are set left side .. means that for QV are text.
I think you are right. How can I fix it?
Can you give us a print screen of your table object ?
Yes they data is there and unfortunly rangesum does not work.
Hope this is enough.
in the script try the follow for the amount field
Load:Replace(Amount,'.',',') as Amount
The issue here is that the point character is not the decmal sep.
Thanks Gabriel your solution worked.
try to punt in the pivot table one more expression with a constant value ... example 1 and see if the values show
Retrieving data ...