+ Reply to Thread
Results 1 to 5 of 5

Pivot table Analysis %'s and Visualization

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    50

    Pivot table Analysis %'s and Visualization

    I have a pivot table that has a column with a # of certificates issued by country and corresponding export sales by country covering 5 years.

    Certificates are not issued for each country. I definitely need to compare the total $ of export sales of countries certificates are issued vs all countries with export sales. Also I need a percentage comparison, so for example certificate countries export sales % of total export sales.

    Also, any further slicers or visual analysis that show trends or represents what values and %'s would be if additional countries were added to the list that exports are issued. So for example if certificates were issued to Mexico then certificates countries would go from ~60% to 80% of total.

    Really just open to any suggestions on how to best represent the data.

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    50

    Re: Pivot table Analysis %'s and Visualization

    If I could at least determine a way to figure out the % that would be extremely helpful. So: certificate countries export sales % of total export sales.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,565

    Re: Pivot table Analysis %'s and Visualization

    If I understand correctly then try using the following formula for B202, D202 etc (the export $ columns): =SUMIFS(B2:B198,C2:C198,"<>-")
    As to visual analysis that show trends perhaps the two pivot table charts on Sheet4 are close to what you have in mind.
    If the above are not what you want, I suggest that you upload a small data set, perhaps 4 countries and a few years which may make it easier to come up with your analysis/visualization tools that may then been applied to the entire data set.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    50

    Re: Pivot table Analysis %'s and Visualization

    Thanks!, this gives me a good foundation for what I'm looking for!

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,565

    Re: Pivot table Analysis %'s and Visualization

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. PowerPivot 2016: Help with data visualization using pivot chart
    By jlt199 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-02-2018, 01:37 PM
  2. Power View Table Visualization
    By CaitlinKnox in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2017, 05:07 PM
  3. Pivot Table Wk over Wk analysis
    By morerockin in forum Excel General
    Replies: 0
    Last Post: 03-10-2015, 12:52 PM
  4. [SOLVED] Opinions on Pivot Table Analysis
    By efarkouh in forum Excel General
    Replies: 11
    Last Post: 08-20-2014, 03:20 PM
  5. Pivot table Analysis using a formula
    By stephboucher in forum Excel General
    Replies: 2
    Last Post: 09-08-2011, 09:31 AM
  6. [SOLVED] Pivot table analysis
    By Nikki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-26-2006, 01:05 PM
  7. [SOLVED] Pivot Table analysis
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2006, 02:40 AM

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