I am building out a dashboard with some basic graphs/pivot tables for my colleagues to use. Previously we just had a single database sheet but no visualization/summary.
For each entry there is a date, some project information - then 5 sets of columns with different bids from prospective investors. We sell two types of products - so of those sets of columns includes a the Bidder, Product Type 1 Bid Price, and Product Product Type 2 Bid Price.
I currently just made a dashboard using the highest of the bids for each project. My supervisor would like to see an average of all the bids but also still disaggregate by bidder. Is there any way to do this? I understand I could make an average column for all of the bids - but that wouldn't allow me to still disaggregate by bidder and would be a little unbalanced for the quarterly average.
I uploaded an example of the my data type (de-identified). I'd like to be able to make Table 2 but with the data from all 5 bids.
I am using a Mac and wondering if there are any pivot table options to group this data. I know how I could do this all by editing the data set but I need it to be dynamic and easily updated.
Thank you!!
Bookmarks