Hi
I am trying to create a pivot table based on this
[TABLE="width: 803"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 803"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]No.[/TD]
[TD]Invoice
Date[/TD]
[TD]Company[/TD]
[TD] Net Amount (£) [/TD]
[TD] Infrastructure [/TD]
[TD] M&S/Aldi/Retail [/TD]
[TD] Safeline [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>[TABLE="width: 722"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]8.13[/TD]
[TD]28/02/2017[/TD]
[TD]Stace[/TD]
[TD] 12,000.00[/TD]
[TD] 3,050.00[/TD]
[TD] 2,155.00[/TD]
[TD] 6,795.00[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>I put company and invoice date in row labels
sum of net amount in values and M&S in report filter, this was the only way I could then de-select the blank lines in M&S
When I choose these options this is what appears
[TABLE="width: 254"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD]Sum of Net Amount (£)[/TD]
[/TR]
[TR]
[TD]Stace[/TD]
[TD="align: right"]£12,000.00[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
As you can see what I would like is the 2155.00 to show not the line total?
Regards
Stephen
I am trying to create a pivot table based on this
[TABLE="width: 803"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 803"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]No.[/TD]
[TD]Invoice
Date[/TD]
[TD]Company[/TD]
[TD] Net Amount (£) [/TD]
[TD] Infrastructure [/TD]
[TD] M&S/Aldi/Retail [/TD]
[TD] Safeline [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>[TABLE="width: 722"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]8.13[/TD]
[TD]28/02/2017[/TD]
[TD]Stace[/TD]
[TD] 12,000.00[/TD]
[TD] 3,050.00[/TD]
[TD] 2,155.00[/TD]
[TD] 6,795.00[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>I put company and invoice date in row labels
sum of net amount in values and M&S in report filter, this was the only way I could then de-select the blank lines in M&S
When I choose these options this is what appears
[TABLE="width: 254"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Row Labels[/TD]
[TD]Sum of Net Amount (£)[/TD]
[/TR]
[TR]
[TD]Stace[/TD]
[TD="align: right"]£12,000.00[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
As you can see what I would like is the 2155.00 to show not the line total?
Regards
Stephen