How to pivot on an InputField

[Anonymous]

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

[el_aprendiz111 · Accepted solution]

Hi

2 options

1- Calculated Dimension :  =Aggr(Dual(Inputfield, RowNo(TOTAL)), Inputfield, [Ref Series])

2- chart Type = Straight Table

[Siva_Sankar]

Can you upload the qvw file?

[Anonymous]

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