Hi everyone,
I am preparing estimates for a building project. It is useful to see estimates in the format of Description, Quantity, Unit, Rate and Total.
Issue One
I would like to be able to show the unit of measurement and rate in the Pivot. The unit column is a text column and the rate column isn't something that I need to add up.
Issue Two
I assume that achieving a solution to issue one will mean that any differences between rates and units will flag up. I.e. there are four instances of "Paint walls" in the table, but three instances in the desired Pivot.
If anyone has a solution for this I'd be grateful.
Thank you
Tom
Bookmarks