summarized data

  1. D

    Pivot Table Does Not Show Separate Lines for 2 Rows of Data That Match

    I am using Excel 2013. I have a large data field from which I have created a Pivot Table. One of my fields is "Amount". When two rows in the data field exactly match one another, the Pivot Table Rows area only shows one of the rows, but the Values area Sums the two rows for Amount. I would...
    • DMumme
    • Thread
    • missing data pivot table 2013 summarized data
    • Replies: 2
    • Forum: Excel Questions
  2. G

    Trying to do some custom Pivot Table summaries, wondering if this is possible...

    Hi all, Pretty straightforward question, I hope. I have a data set that I'd like to see if I can get set up in a pivot table in a custom way. The data is being pulled out a SQL database and looks like this when I retrieve it (dummy data created for example purposes - its actually quite a bit...

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