I have a Field called Material code which contains some data.
I have to add 0 as a dummy value for each Records.How can I do this in the script.Could Anyone help me in this
Can you elaborate more about your expected result?
When I select one material code,it'll show some value. if there is no value means it should display 'Zero'.
I used pivot table and not getting proper result in 'Show all values and Suppress Zero values'.
So I planned to create some dummy data for each material code.
I am sorry, If i misunderstand the Rek. Better if you provide sample data and expected result
From below, What are you expecting?