Average sales per store

[#1]

Hi

i have several salesmen  per  store. i need to present averege sales per hour for each salesman and average sales per hour for each store in the same table. i need that the calculation of the average per store won't change when i add "SALESMAN" column to the table

                                                Average per salesman     Average per store

STORE A   SALESMAN A                   x                                      w

STORE A   SALESMAN B                   y                                      w

STORE A   SALESMAN C                   z                                      w

STORE B   SALESMAN D                   v                                      p

STORE B   SALESMAN E                   n                                      p

thx in advance

[bbi_mba_76]

Hi,

maybe with aggr(nodistinct avg(SALES), STORE)

[Jason_Michaelides]

For average per salesman:

Avg(Sales)

For average per store:

Avg(TOTAL <Store> Sales)

For overall average (if required):

Avg(TOTAL Sales)

Hope this helps,

Jason