Add records in column?pls give me idea?

[narender123]

Hi All

I have a table with field Tax type . In this tax type column there is 9 tax type name.I want to add more tax type name in this field .The tax type names that i want to add is made by some conditions in set analysis and different tax type name having different condition.How can i do this????????

eg:

Tax Type            Amount

alcohol              1000      (set analysis =sum({<year={$(=max(Year))},status code={350,360},Flag={'A'}>}Amount)

Duty                  5000      (set analysis =sum({<year={$(=max(Year))},status code={350,360},Flag={'A'}>}Amount)

bottle levy            10000    (set analysis =sum({<year={$(=max(Year))},status code={350,360},Flag={'A'}>}Amount)

and the tax type that i want to Add in Tax type are

MERCTAX           15000  (set analysis = sum({<ALLOCTRANTYPE={'MERCTAX'},Flag={'P'}>}AMOUNT)

OFFPAY'             20000    (set analysis =sum({<ALLOCTRANTYPE={'OFFPAY'},Flag={'P'}>}AMOUNT)

.

.

Thanks.

[narender123]

Hi Guys,

Any Idea????

Thanks

Regards:

Narender

[narender123]

Hey is it possible.Pls Tell me???

[#4]

Hi,

Create a Inline Table with the TaxType that you want and then concatenate it with the original table.

Thanks,