In my Excel file, sheet pivot.
How can i show only the Duration and Amount Granted per year, i dont want to SUM those figures because of no meaning when sum those figures.
Also i want to insert 1 new column "Total Amount Granted". This column's value is (Duration *Amount Granted per year). And i want to sum this column.
Finally, how can i do the chart which show ONLY "Total Amount Granted" (not Duration and Amount Granted per year).
I hope someone can tell me the way to do, because i need to understand the strategy.
Thank you very much. I really need the answer![]()
Bookmarks