How to autofill or repeat the cell value in Pivot table

Help Studio
, , , ,
1

I am reading the data from Excel Pivot table using excel process scope ‘Read Range’ activity and assigning to the datatable.

Pivot table data looks like this

image
image1021×631 132 KB

The issue is when assigning this to the datatable, ‘CustomerGroup’ column value is empty for all the rows excpet A4. Because of this i am not able to filter the datatable based on CustomerGroup, since Datatable don’t know that Row A5 also belongs to “Alibaba CSP”.

Is there any way to auto fill the empty cell or repeat the value of the cell to other rows so that it is easy to identify?
Can this be done using excel Pivot options? i am ok with that also.

Please suggest and thanks in advance

2

Hi @raja.raviraj ,

Please select ‘Repeat All Item Labels’ under Report Layout in the Design tab as shown in below screenshot,

image
image731×335 75.3 KB

Hope this might help you :slight_smile:

3

Thank you …this helps

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.