I need to layout an excel tabular data sheet so that I can create an interactive dashboard for my end result.
What we currently have for a report:
Tabular data sheet working on:
I still need to work on formulas, but I need to make sure I have the format correct for the tabular data sheet first.
What I need to have in the tabular data sheet:
Region
Skills
# of skills per region
% is # of skills per region divided by the number of JP's
Job Postings per region
I wanted to make sure I am on the right track with the tabular data worksheet I uploaded/added picture of.
Thank you
Adriane
Hi,
It looks to me that you are on track.
/Anders
I'm not sure if you calculate the percentages the right way on the dashboard (in the middle I see for instance 100% and 50% and 50%, which makes 200%), but maybe you are working on that too.
One advice: you have two blank rows in your datasheet. As I learned Excel doesn't like blank rows (or columns). So skipp them.
Good luck!
Frans
