Hiiii,
Thanks for looking by..
i have attached an excel sheet.
i have a sheet named input..where i have a table.
i have made a pivot from this table in the pivot sheet.
my problem is i dont want the amounts h and i to come together
i want it separate as shown in the output required.
instead of two entries i will have four entries for example.
in my actual scenario i have many entries..but i have just put two entries in the sheet.
is there a way i can do this??
Many Thanks
Gokz
Bookmarks