I have a table with Columns as "Demand" and "Receipts" for each day, from which "Pending Collections" (= Demand - Receipts) is calculation in another column.
After summarising, Since all these are columns and a PIE visualisation needs data points to be in rows i am not able to visualise same in a pie
Current data format (tabular view)
Collections Pending Collections
Needed Data Format
Pending Collections 15000