Sum up the total items in the dashboard

[kachuen2006]

Dear All,

can anybody teach me how to sum up the different items in the log sheet and display in the dashboard sheet?

Thank you very much

[oeldere]

See if what is on blad 1 is what you want.

If so, I could explain how i made that.

Notice that i inputted 2 columns in the sheet log.

I marked them with red (and black text).

See the attached file.

[kachuen2006]

Thanks for your prompt reply Oeldere.
May be i need to explain in details.. i need to count the total number of different items in the log (.e.g. Mic-Key Low Profile Gastrostomy Feeding Tube, Gastrostomy Feeding Tube, Kimberly-clark, and Compat, Nasogastric Tube), regardless of their reference no., and display it in the right hand side of the dashboard sheet. i tried to generate the three worksheet name" MasterXXX" to count the number, however i still stuck in it as i didn't know how to paste the number to the color box in the dashboard sheet
Thanks for your kindly help

[oeldere]

Like this?

[kachuen2006]

Bingo, Thanks Oeldere, can you teach me how to do that?
Also, if i want to copy the "End total" to the other worksheet? What can i do ?

[kachuen2006]

Dear Oeldere,
I ve updated my file. what i want is to link the number marked them with red (and black text) to the right hand side of the "dashboard" worksheet, can you tell me how to do that?

[oeldere]

For the pivot table under #4.

excel 2007
In any cell of the table your click on:

Insert => pivot table.

A pop up will come up.

The first radiobutton give the name of the table.

The second (we don't use)

The third ask if you want to put the pivot table on another sheet / or in a cell on e.g. the same sheet.

I choose for new sheet.

Then you get an new sheet with an empty pivot table (on the left side).

On the right side you find boxes where you define the input in the pivot table.

I dragged into the box (row) => year , month, description

I dragged discription in the box (values)

In the value box you been able to count / sum / average the data.

I choose for count.

Now you know the basic of pivot table.

You can drag and drop the choises in the boxes and see what happens.

If you only want the totals, you don't select the year and don't select the month.

Please reply if I explained it well enough.