Hi,
My report consists of a column with (country + state) combination for example "Us-Newyork, Us-alabama, Canada-Ontario....". Now after listing all the US states I am generating their totals for whole states. Issue is to be listed immediately after all of that country respective states.
For example after all US-states "US-Total" should come, after all canada "canada-total..."
Please can anyone let me know how to do this in cognos 8.4.
CURRENT OUTPUT
US-MASSACHUSETTS
MAUHMS
MAUMPB
MAUTUF
US-MARYLAND TOTAL
MDUIMD
MDUJHU
MDUIDB
MDUMIH
MDUMLM
US-MINNESOTA TOTAL
MMUMAY
MMUMIM
CANADA-MANITOBA TOTAL
MBBAMM
MBBBFB
MBBDRG
MBBTAV
MBBVSS
US_TOTAL
CANADATOTAL
SUMAARY
REQUIRED OUTPUT
US-MASSACHUSETTS
MAUHMS
MAUMPB
MAUTUF
US-MARYLAND TOTAL
MDUHMD
MDUJHU
MDUMDB
MDUMIH
MDUMLM
US-MINNESOTA TOTAL
MMUMAY
MMUMIM
US_TOTAL
CANADA-MANITOBA TOTAL
MBBAMM
MBBBFB
MBBDRG
MBBTAV
MBBVSS
CANADA TOTAL
SUMMARY
Thanks,
My report consists of a column with (country + state) combination for example "Us-Newyork, Us-alabama, Canada-Ontario....". Now after listing all the US states I am generating their totals for whole states. Issue is to be listed immediately after all of that country respective states.
For example after all US-states "US-Total" should come, after all canada "canada-total..."
Please can anyone let me know how to do this in cognos 8.4.
CURRENT OUTPUT
US-MASSACHUSETTS
MAUHMS
MAUMPB
MAUTUF
US-MARYLAND TOTAL
MDUIMD
MDUJHU
MDUIDB
MDUMIH
MDUMLM
US-MINNESOTA TOTAL
MMUMAY
MMUMIM
CANADA-MANITOBA TOTAL
MBBAMM
MBBBFB
MBBDRG
MBBTAV
MBBVSS
US_TOTAL
CANADATOTAL
SUMAARY
REQUIRED OUTPUT
US-MASSACHUSETTS
MAUHMS
MAUMPB
MAUTUF
US-MARYLAND TOTAL
MDUHMD
MDUJHU
MDUMDB
MDUMIH
MDUMLM
US-MINNESOTA TOTAL
MMUMAY
MMUMIM
US_TOTAL
CANADA-MANITOBA TOTAL
MBBAMM
MBBBFB
MBBDRG
MBBTAV
MBBVSS
CANADA TOTAL
SUMMARY
Thanks,