Topic
  • 1 reply
  • Latest Post - ‏2013-01-22T14:42:48Z by DanielWagemann
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic # of total rows in a crosstab depending on #of distinct values in a column

‏2013-01-21T14:44:47Z |
Hi all,
I have a crosstab like this:
month | product | amount
01 | P1 | 100
01 | P2 | 200
02 | P1 | 300
02 | P2 | 400
03 | P1 | 500
03 | P2 | 600

In this case I would like to have this total:

Total | P1 | 900
P2 | 1200

but if I have:

month | product | amount
01 | P1 | 100
02 | P1 | 300
03 | P1 | 500

I would like to have:

Total | P1 | 900

Is it feasable?

Thanks
Updated on 2013-01-22T14:42:48Z at 2013-01-22T14:42:48Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: # of total rows in a crosstab depending on #of distinct values in a column

    ‏2013-01-22T14:42:48Z  
    Two questions ... is this a relational, OLAP or DMR package?

    Also what happens when you take month out of your crosstab, do the records roll up properly?