I have powerbi attached to SAP.
This brings in a list of documents.
These documents have:
1) document number
2) purchase order number
3) line on purchase order
4) dollar amount
Some times, there are 2 seperate postings in the same document, on the same purchase order, on the same line on purchase order, with the same amount.
SAP shows these as 2 seperate line items.
My powerBI table is showing this as a total amount.
How do I get powerBI to show the line items view for each amount rather than grouping amount?
Solved! Go to Solution.
You can change dollar amount to Do Not Summarize instead, skip to Ways to Aggregate Your Data here in this link for reference:
I deleted the field from the table and added back, no luck.
Tried to delete table and create a new one, still no luck.
I'm not sure if I'm doing it properly, but Im not able to chose
dont summarize from the fields pane.