Dashboard

Dear doug or Jen

I went to Dashboard Training on 3 Nov, and learned a lot.

I have come across this when establishing dashboard in practice:

I can produce pivot charts and link them via slicers.

But I don't know present the raw data in complex table with slicer linkage.


The required dashboard format is complex table with slicer:

14 Columns and 3 rows

Column 1-6 are
Applications, Offers, Pending, % of Pending, UFs, % of UFs out of replies

(The rest columns are the similar to 1-6)

Rows 1-3 are
Year 2015
Year 2014
Yr-on-yr chang

I am processing raw data via calculation so columns in required table are also ready in raw data.

But I have to produce one pivot able for each cell at the moment, and link all to dashboard with slicer.

Could you suggest any simpler and proper way?

Is there any way I can attach the data tables, so the discussion will be a lot easier.

Many thanks.

Xiaorong Goh