Hi,
I have a report based on Excel data. I want a column chart that shows the actual values. Although I have made sure the Y-axis data is numeric and set "Do not summarise," I can't stop it from summarising the data.
In the screenshot, if we use Cost as an example, the highest cost is £5099.99, but the column indicates ~£12,000.
These are the options on the Y-axis field:
I have read countless posts on this and cannot get it to simply show the values as they are in the table (data).
If someone could help me out, I'd be very grateful.
Thanks in advance.
1 ACCEPTED SOLUTION
Try changing it so Maximum. If you use want to use it in a visual, it has to be aggregated, but i think in this case, you just want to show the value, so you can either use Min and Max.
Thank you @Tutu_in_YYC,
That has worked.
Now to get independently scaled secondary Y-axis without paying extra...
Try changing it so Maximum. If you use want to use it in a visual, it has to be aggregated, but i think in this case, you just want to show the value, so you can either use Min and Max.
