I want to use a manual input field to be the pivot point for a pivot table, rather than a field from the database. However each line is being treated as a separate pivot, even though at the moment they all contain exactly the same data.
This is what I currently have (all the inputfield entries are C12345):
But I want it to look like this:
Can somebody help me to get the correct result please?