Hi, I have created a pivot table and I want to repeat the row label items. Is it possible to use excel activities or there is any other approach? Can someone help?
lrtetala
May 17, 2024, 6:47am
2
Hi @Amit_Kumar_Charde
Can you please provide sample input excel and output, Meanwhile try with Auto Fill activity
Hi @raja.raviraj ,
Please select ‘Repeat All Item Labels’ under Report Layout in the Design tab as shown in below screenshot,
[image]
Hope this might help you
Regards,
Sure here is the screenshot.
Here I want to remove these subtotals which are in red boxes.
Anil_G
May 17, 2024, 7:32am
4
@Amit_Kumar_Charde
you can use find/replace activity and find total and replace with blank
cheers
@Anil_G I want to delete all the rows which include “Total”.
Anil_G
May 17, 2024, 10:31am
6
@Amit_Kumar_Charde
use find to get thw row number and then use the retrived row number in delete rows
cheers
lrtetala
May 21, 2024, 7:05am
7
@Amit_Kumar_Charde
Can you try the below
Sequence19.xaml (18.2 KB)
Or try this
Regards,
Invoke VBA activity was helpful for me.
system
August 8, 2024, 8:25am
9
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
