Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Rushali
Contributor
Contributor

How to repeat the same value in different columns but the same row in pivot table

For eg. Pivot table. Basically where I am reflecting names, there is different field which is a concatenation of two fields which should be duplicated in all the months depending, if there is no specific value assigned for a particular month, but we no know the quarter only.

Country                        Quarter        Months

                                           q1                                                          q2

                                     Jan   Feb  March                            april  may  June

x                                  Pooja  Pooja  Pooja                   Ria       Ria    Ria

y

z

 

Labels (5)
0 Replies