Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table of data in pivot table. like below
I need a additional column of S.No(Serial Number) in front of the table.
I saw a solution of addition of column in script but it is waste of use. Because it shows the value stored in the table not the dynamic values while apply filters.
So any body help me.
regards,
Yoganantha Prakash G P
May be using a calculated dimension like:
=Aggr(RowNo(total), ...,Dim2,Dim1)
Hi Yoganantha Prakash G P,
Are you able to provide some sample data/qvw for testing?
Warm regards,
Nish
Hi Yoganantha,
Use the below as expression and move the column to front of the table.
=RowNo(TOTAL)
Hi nagaraj,
I can move till the previous expression but I cannot move beyond which has more dimensions in front of it
Hi Yoganantha,
Looks like you are using pivot table. If that is the case, you can use Tresesco's solution.