PivotSelect for changes data

[scatachi2]

Hi all,

I have a problem with PivotSelect for a changes data.

I have a raw data that changes everyday and I am creating a pivot table to get my result.
The data may include Item1 Item2 and Item3, but sometime the source (data) may only have Item1 and Item3 (No Item2)

Below is my code:

Please Login or Register  to view this content.

]
My pivot will work if all 3 items are in the source data, but if Item2 is missing (No Item2) from the source data, I will get an error and the group isn't created.

I really appreciate for any help to solve this error.

Many thanks in advance.

scatachi2

[Cheeky Charlie]

Please put your code in code tags - edit post - go advanced - select code - click # icon.

[scatachi2]

Hi all,

My pivot will working if the data is matching, if one of the item is missing it will not caption and create a group.

Please Login or Register  to view this content.

Appreciate for any help..

[Cheeky Charlie]

Why do you need to recreate the groups each time? Couldn't you use the same pivot?

Anyway, a way of doing it would be to test for the existence of each entity in your source data (e.g. find is nothing) then group whatever has been found.

hth

[scatachi2]

Hi Cheeky,

Thanks for ur feedback, actually i tried to modify the code but still getting error, do you have any idea how can i modify the code..

Many thanks in advance..

[Cheeky Charlie]

Yeah

a way of doing it would be to test for the existence of each entity in your source data (e.g. find is nothing) then group whatever has been found

I could show you if you uploaded an example