+ Reply to Thread
Results 1 to 2 of 2

two Pivot Tables One pivot chart

  1. #1
    Registered User
    Join Date
    03-02-2006
    Posts
    54

    two Pivot Tables One pivot chart

    hi, I have a pivot table that shows the % difference for a groups forecasted results and a pivot table that shows % difference for actual results.

    Is there any way to have both of these records sets shown in one table and then one chart without going down the path of multiple consolidation ranges? I'm not particually well versed in this area and following this path does not show the data as i would like it e.g I need to see the actual values of the two pivot tables rather than a count or sum of them.

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690

    consolidation of pivot tables

    I don't fully understand your query but if for January the target was 100, the forecast was 97 and the actual was 95, your 2 pivot tables presumably show
    -3% and -5%


    I suggest you ditch the pivot tables and replace them with 1 sumproduct table

    =sumproduct((a1:a5=deptA)*(b1:b5="january")*(c1:c5>0)) is the type of equation assuming your %diff_forecast_from_target figures are in column C

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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