SOLVED
Cross tab Issue
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ShreyaSharma
8 - Asteroid
‎08-06-2020
03:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Not sure what should i use a cross tab or a summarize i want it to be like i do on Pivot
Example:
I have two sheets --- Sheet 1 and Sheet 2
Now i want the pivot should look like
now ...We have another sheet 2
Now what i am looking is to add a new column on the pivot created above with the formula..=SUMIF(Sheet2!B:B,Sheet1!B12,Sheet2!A:A) to get the final output
Many thanks
Solved! Go to Solution.
2 REPLIES 2
DavidP
17 - Castor
‎08-06-2020
04:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-06-2020
04:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks