Forum Discussion

argnist's avatar
argnist
Frequent Visitor
8 years ago
Solved

Divide summarized column by another summarized column

Hi all,   does anyone know the way to divide one summarized column over to another summarized column?   When I try something like SUM (Total Sales) / SUM (Items Sold) it calculates it for each it...
  • vcastello's avatar
    vcastello
    8 years ago

    Hi argnist

    Try the following:

    1.- Click New Measure.

    2.- Enter
             Average Per Item = DIVIDE([Total Sales], [Items Sold])

    3.- Put that new measure in the matrix

    Hope That Helps

    Vicente

vcastello's avatar
vcastello
Icon for Resolver III rankResolver III
8 years ago

Hi argnist

Try the following:

1.- Click New Measure.

2.- Enter
         Average Per Item = DIVIDE([Total Sales], [Items Sold])

3.- Put that new measure in the matrix

Hope That Helps

Vicente