Hello,
First time posting here as struggling with Excel.
Work on QlikView and cannot get a Pivot in QlikView to produce the exact data I need.
I can dump it into a straight table and then hoping I could split out the subtotals I need using Excel.
I've attached a spreadsheet with two tabs - 1 is Raw Data and the 2nd tab is SplitOut and shows how it should be done.
This split out is just for 1 customer with their values.
The data will change under "Type de Commission" so the fields need to be dynamic as each raw data may have different values there, however, how they are summed up / split out would be the same.
Primarily it needs to be split to show a subtotal for each product with the same 'Cover Start', 'Cover End', 'Commission Type' and 'Transaction Type'. If there is a different 'Transaction Type' for the Same Product / Agent then this needs to be another subtotal. e.g with Garantie / Support = WH3 & Agent = Agent3. This would need to have two different subtotals due to the different transaction type. And Agent1 for Garantie / Support =DA.
If this is possible please let me know.
Thanks,
Podge
Bookmarks