Skip to Content
avatar image
Former Member

Preparing the report without cross tab

I am having the data as below

and I want to have the report like

Is there any way to create this report without using crosstab

data.png (11.9 kB)
report.png (7.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 06, 2017 at 07:56 AM

    Hi Sree,

    Without a crosstab, you'd need to know each of the ProdGroups. You'd then need one formula each for every ProdGroup.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 08:11 AM

    Hi Abhilash;

    If the groups are known then which formula will help. Could I use a running total

    Sreejith

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 10:28 AM

    You can not use Running totals if you want totals at the top. They are whileprinting functions so can only show totals at bottom

    You will need to create a formula for each Product Group and as Abhilash says you will need to define all possibilities. Thus if you add a new product group in future then you will need to update report. Whereas a Cross tab report they will be included dynamically.

    Formula will look like

    @PG-001

    If ProdGroup = 'PG-001' then qty else 0

    You can then add a sum summary and this can be placed in report header.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 11:27 AM

    Thanks Ian I think it would be better to go with the Cross Tab. Because there are possibilities of creating new groups.

    Sreejith

    Add comment
    10|10000 characters needed characters exceeded