#pivot table

  1. A

    Pivot or Other Solution required to transform the data

    Hi, I attached a photo for a data set I have called" Original Data" where I want to create a Pivot table or any other simple solution to create a new data table as show in the attached photo below:
  2. M

    Removing monthly SUM from Pivot table

    Dear All, In the below pivot table I dont need the monthly sum of GM (Which I have marked with a cross symbol). However I need a total at last ( as shown with a TICK symbol). Is there any option to do this? Please note that I need the monthly revenue and cost figures as it is. Only the GM...
    • MFT
    • Thread
    • #pivot table excel & formula sum a column
    • Replies: 5
    • Forum: Excel Questions
  3. C

    Pivot Table field in Filter and Row referencing to the same column in the data source

    Hi, I took over a report. It has a pivot table that has two fields (Field and Field2 as highlighted on the screenshot). These two fields are referencing to the same column in the data source called "Field". If I double click the 1 data values on the pivot table to generate the data source...
    • couthelle
    • Thread
    • #field #pivot table #row #same field same row and filter field
    • Replies: 9
    • Forum: Excel Questions
  4. K

    Merge cell reference with other formula

    • krunal123
    • Thread
    • #condition formatting #easy excel #excel #comparison #excel #pivot #excelquery #excelquestion #filter #formatting #formula #if #match #index #pivot table
    • Replies: 4
    • Forum: Excel Questions
  5. K

    HOW TOTAL QTY & RATE AS PER PRODUCT VISE FROM MULTIPLE SHEETS

    WE NEED SUMIFS FORMULA AS PER QUERY...... NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS
    • krunal123
    • Thread
    • #easy excel #excel #excel #comparison #excel #error #excel #formula #confused #excel #pivot #excel tricks #pivot table #pivot table#fiilter
    • Replies: 2
    • Forum: Excel Questions
  6. K

    How to Highlight RAW After Bold Text ???

    How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also
    • krunal123
    • Thread
    • #cell #highlight #colour #condition formatting #conditionalformatting #excel #comparison #excel #formula #confused #excel query #ifconditional #logical #if #excel2016 #logicfunction #pivot table #pivot table#fiilter #vba #excel excel & formula
    • Replies: 5
    • Forum: Excel Questions
  7. K

    How to change month After select Dropdown list ???

    • krunal123
    • Thread
    • #condition formatting #conditional formatting #excel #excel #comparison #excel #error #excel #formula #confused #excel #minimum #index #excel question #excel tutorial #formulahelp #pivot table #pivot table#fiilter #pivot tables #tables #sumif #indirect #index #vba #excel #if formula #explaination
    • Replies: 6
    • Forum: Excel Questions
  8. J

    Separate pivot date data into 2 columns

    Hi excel community, It’s finally the point in my life where I realised how powerful but painful excel can be and would like to learn more. As the attached table, I have a simple pivot table stating the names on the first column, and the dates of testing of the second column. For some names...
  9. C

    Count Yes/No in Pivot Table

    Hi all, I am hoping someone can advise me on how to set up my pivot table please? This isn't the best way of setting up feedback analysis I am very sure, but I need to work with what I've got! I have survey results from students who have done a variety of modules for their courses and submit...
  10. K

    @MULTIPLE PIVOTABLE FILTER AFTER SELECT DROP-DOWNLIST

    How to Filter Both Pivot-table Data According After Select Drop-Downlist. "i Try select party name on drop-downlist , After filter both pivotable data on working with drop-downlist (WE NEED MULTIPLE PIVOTABLE AFTER SELECT DROP-DOWNLIST
    • krunal123
    • Thread
    • #advancedfilters #chart #condition formatting #easyexcel #excel #formula #confused #excelquery #excelquestion #pivot #pivot table #pivot table#fiilter #pivotquery excelfilter
    • Replies: 0
    • Forum: Excel Questions
  11. K

    How to Get Number Between Slash "/"

    Between two Slashs "/" Or Two and more Slashs how to work formula in this condition
    • krunal123
    • Thread
    • #condition formatting #easy excel #excel #excel #discrepancies #excel #formula #confused #excel #pivot #excelguru #excelquery #excelquestion #filter #formula #highlight#cell#based#value #logical #if #excel2016 #pivot table
    • Replies: 4
    • Forum: Excel Questions
  12. K

    How to marge 3 table , Without loss data ???

    I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.
    • krunal123
    • Thread
    • # excel filter #condition formatting #excel #comparison #excel #formula #confused #excel #pivot #excel query #excel question #excel tips #excel tricks #pivot table #powepivot #powerquery #power query #table formating #vba #excel #if excel & formula excel tables
    • Replies: 3
    • Forum: Excel Questions
  13. K

    HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST

    # HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....
    • krunal123
    • Thread
    • #excel #excel formula #excel query #excel question #excel tips #pivot table #power query excel formula vba
    • Replies: 3
    • Forum: Excel Questions
  14. K

    # How to Extend range in pivot tables ?? ?

    I was try refresh but not show data in pivot table, how to update data ...???
    • krunal123
    • Thread
    • #database #pivottable#vba #excel #excel #formula #confused #pivot table #power query excel question
    • Replies: 1
    • Forum: Excel Questions
  15. K

    Hide Row with Zero value with Entry

    Hide Row with Zero value with Entry
    • krunal123
    • Thread
    • #conditional formatting #excel #excel #formula #confused #excel query #excel question #excelguru #excelhelp #pivot #pivot table #power query #vba #vba #excel
    • Replies: 1
    • Forum: Excel Questions
  16. K

    How replace Range to table name ?????

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top