Pivot data with multiple conditions

Dear All,

I'm trying to pivot data or utilize formulas or VBA. The file is attached. The data is coming from the Data Base tab to Output tab, which at this point has the data manually altered/input. Eventually, I'd love this to be done without my involvement. I'm trying to pivot data in a way that if the document Name (column C) breaks down data per countries (regardless of the number of TYPES), the pivot should sum up the Net USD (col H), % (col G) and TOTAL (col J) per countries. If the document NAME (column C) breaks down the data for only one COUNTRY (col E) but multiple TYPES (col K), then the pivot/formula should sum up NET USD (col H), % (col G) and TOTAL (col J) per TYPE (col K). All of the above should only take the largest REV # (col L) regardless of the STATUS (col M).


Any help would be much appreciated

Oldere,

I figured how to upload the file. Please see attached.

Hi figured it out. The helper columns on the main data table have to be created.
1. First helper column determines the number of the version
2. second determines the latest version or the largest per document name
3. Displays latest vs previous, to the largest and all other ones, respectively
4. this column should display number of unique items in countries column per document name
5. If the number in 4th helper column will be above one, it will display country, otherwise type
finally, pivot table, with filter for the latest and one of the row 5th column data