In your "full data" view what does the column Amount - NAV Count look like?
Thanks for your reply.
"Amount - NAV Count" is a calculated field. In The "full data view" every row is showing as null. Makes no sense to me that on the worksheet there are values but it shows all null in the main data set. Could that have something to do with how the measure value is using AGG rather than SUM?
Thanks for looking at this, really is appreciated.
It shows null in the full data because that value doesn't exist in the full data (because it's calculated)....The AGG part just means the the "Sum" is done within the calculation (for example sum(Sales)/Sum(Profit) = AGG(Profit Ratio))
Would it be easier to navigate to the datasource tab and view the data in there? You could set the datasource filters to view just the account in question and see all of the line items that make up those numbers?