Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Many thanks
Mike
Hi
2 options
1- Calculated Dimension : =Aggr(Dual(Inputfield, RowNo(TOTAL)), Inputfield, [Ref Series])
2- chart Type = Straight Table
Hi
2 options
1- Calculated Dimension : =Aggr(Dual(Inputfield, RowNo(TOTAL)), Inputfield, [Ref Series])
2- chart Type = Straight Table
Can you upload the qvw file?
Hi Fer Fer
Many thanks for your reply. Changing the table to a straight table didn't work, but using =Aggr() worked!
Thanks again
Mike