Results 1 to 7 of 7

Data Dashboard

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Data Dashboard

    Hey everyone. I'm struggling to build a dashboard and am looking for some assistance. I've attached a copy of the data I'm working from. What I'm trying to do is show monthly performance based on products of a few different areas. Where I'm running into problems, is with the month listings. If the report shows one month at a time, I can get it to work with SUMIF formulas, however when there is more than one (and there will always be three), I can't figure it out.

    Any help would be appreciated.

    ~B



    Excel Forum Sample File.xlsx
    Last edited by Black0ut; 03-11-2014 at 03:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Interactive Dashboard and data filtering
    By cloudno9 in forum Excel General
    Replies: 11
    Last Post: 11-27-2013, 02:50 AM
  2. Data Seek in Dashboard
    By kingshank in forum Excel General
    Replies: 0
    Last Post: 05-17-2013, 05:48 AM
  3. create a dashboard or new way to present the data
    By SAMEEP in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2013, 08:56 AM
  4. data dashboard
    By emorocks83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2010, 01:27 PM
  5. Raw Data Filter Help! - Dashboard
    By noel414 in forum Excel General
    Replies: 1
    Last Post: 06-23-2008, 07:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1