While i am preparing a data after pivoting it displayed like this
After the run, the data is displayed in this way
I need the the values to be dispalyed in one row as displayed in the recipie. can someone help with it
the pivot processor outputs one row per input row, so the display in the design mode of your prepare recipe indicates that the first processor (remove kpi) removed all rows but one.
In any case, after a pivot recipe, if you want to re-group rows by some subset of the columns, you need to use a Group recipe