Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three attributes:
orderyear,
ordermonth
and amount
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?
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.
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.
BR
I think you are right. How can I fix it?
Yes they data is there and unfortunly rangesum does not work.
Can you give us a print screen of your table object ?
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.
try to punt in the pivot table one more expression with a constant value ... example 1 and see if the values show
Thanks Gabriel your solution worked.