Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

**rikkyshh** · 08-21-2013, 12:12 PM

Please see attached for a design template

Pivot tables are not letting me present the data how i want to

Please see Income Sales Tab, data is fed from the RS working sheet

I would like the data to be presented as shown on the Income sales sheet row 25 onwards

**Kyle123** · 08-21-2013, 12:20 PM

Where do:

L/O R/C F/M

Come from?

**rikkyshh** · 08-21-2013, 05:00 PM

Hi they are drop downs for 3 diff management type categories, pulling from the "Do not touch" sheet

**Roger Govier** · 08-21-2013, 05:12 PM

Hi

The you either need to put the relevant :/O, R/C or F/M data on your RS Working sheet and extend the source for your PT, OR, you need to use Power Pivot and set up some relationships.
As it stands, what you are asking is impossible.

Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

LinkBack

Thread Tools

Rate This Thread

Display

Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

Re: Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

Re: Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

Re: Pivot tables are annoying me, how do i do automatic totals without using pivot tables?

Thread Information

Users Browsing this Thread

Similar Threads

Copying worksheet with pivot tables into new workbook, pivot tables not moving with it?

Row Totals in Pivot tables

Pivot Tables - Grand Totals

Pivot Tables-Not Display-Results w/Zero Totals

Calculations using totals generated in Pivot Tables

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions