Total Sales

[#1]

Hi all,

I have a straight displaying a number of expressions, but I need to display the total historical sales as an expression that is not affected by any selections, If I use set analysis ({1< etc is expands the whole table and will not therefore allow any selections to reduce the data to an indiviidual product or item.

Can anyine tell me how I achieve this?

The Straight table has 3 dimensions, Item Short Name, Supplier & Platform.

=sum({<[SOP Type]={'Invoice'}>} Quantity) - is my current solution

I had thought aout displying this info as a calculated dimension? Is this possible?

Regards

Richard

[kaushiknsolanki]

Hi,

   Can you please upload the QVW for more reference and understanding of your requirement.

Regards,

Kaushik Solanki

[#3]

As requested please find attached qvw file.

Many Thanks

Rich

[yasus · Accepted solution]

Hi Rich,

you can use the "Ignore-Selection-Modifier", in order to show allways the total sales.

sum({<
          [SOP Type]={'Invoice'}, 
          %Key_Calendar=,
          Month=, 
          CalendarYear=
     >}  
[Extended Price])

[#5]

Gregor,

That seems to have done the trick,

Thankyou very much.

Richard