Cannot get pivot table to work at all

Hi guys,

I have been a member on here before but don't have access to my email account linked, so registered again.

I am trying to create a pivot table (well I have) but it is not behaving as it should be.

Please could somebody have a look and tell me where I have gone wrong with it?

I just want it to calculate a shopping list of items required to make meals on a large scale.

It is not picking up any of the values at all and is displaying 0.

I have attached the file for you to look at.

Many thanks in advance.

Dan

If you edit the source data in the costings sheet, you must refresh the data for it to be reflected in the output on Sheet1.

Data -> Refresh All.

All assuming you have Power Query add-in installed.

I do not have the power query option.

Can this not be done with a pivot table?


Thanks

Originally Posted by alansidman

Here is another solution. Copy the data in column B and paste in Column A at the bottom of your current data. I used A48. Now remove all duplicates from this new list using the built in Remove duplicates function found on the Data TAb. Now in B49 insert this formula and copy down. =SUMIF($B$2:$B$43,A49,$L$2:$L$43)

Attached is my solution.

This is great!! Would it be possible to put the ingredients list onto a separate sheet rather than underneath? Then I can add more meals in as I create them.