Dear all,



Is possible to add values from 2 or more different variables with excel 2007 pivot tables ?

I have added the file in which i put some details about the results I am looking for with pivot tables. i am able to find an alternative to this solution so I am only interested if pivot tables are a solution to this problem

Thank you,
Andrei

Attached Files

Sample_file.xlsx (16.1 KB, 11 views)

This solution is a bit long winded but it works

What we want to do is to normalize the data you provided

Add a column before your data (sheet1) and let's call it Line (or anything you want)
Enter a name for each row ( say L1 and pull down)
Now press Alt+D then P - you get the 2003 Pivot Table wizard
Check "Multiple consolidation ranges"
Next
Check "I will create..."
Next
Select the range ( in our casee A2:E9)
Click "Add"
Next
Select where you want the result
Finish

You now have a Pivot Table which IS NOT THE ONE YOU WANTED

Still some work to do..

From the PT Field list, drag the row and column tab off the grid ( or uncheck them)
You are now left with two cells
One containing "Count of Value" ( or another function) and another with a number (19 in your example)
Double click the 19 and in a new sheet (sheet4) appears your normalized list

Starting from there you can apply the usual PT techniques after providing for row and column headings eventually.

Attached Files

Sample_file.xlsx (23.8 KB, 10 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Great solution!!!

Regards,
Andrei