pivots table

  1. N

    Click on a pivot chart and get the table data ... Possible?

    Hi, Building a dashboard and displaying lots of charts. However sometimes the use might need to see all the details. The details not displayed on the charts. Is there a way to click on the chart or a column/line on the chat and get back to the full details? FYI - all these charts are tied...
  2. M

    Pivot table/chart help!!!

    Hello, I am trying to create a pivot table from data that I have collected from a group questionnaire, there is 40 questions. Each question has about 5 different answer options. Every time I go to create the table it adds all the answers up to give me a total of people that answer. I already...
  3. L

    Filter a pivot based on date in a cell

    Hello, My pivot table contains dates and product received. I am trying automate the filtering of date in pivot, so that when i enter a date in a desired cell, pivot would filter with the date in the cell and return the number. I have put up the following code to achieve this. But ended up with...
  4. D

    Pivot Chart Help

    Hi All, How to integrate contents of rows as headers in values field of pivot table. Please find the attached to understand the question better. Thanks in Advance Divakar file:///C:/Users/divakar_k/Desktop/Mrexcel.JPG C:\Users\divakar_k\Desktop\Mrexcel.JPG
  5. M

    Expanding Fields in Excel 2007 Pivot Table

    Hello... anyone feeling on the ball on Monday morning? I have a pivot table (Excel 2007) with 3 groups before a count field: Country / Drink / Size / Count of names The issue is when I expand an item in the second group (say Lager) for a country (say UK) that item expands in all country...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top