Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to work on an application wherein for every month I need to show data for 3 months. eg:
Sales Month = Jan, Show sum of Pipeline for Sign Date between Jan and Mar
Sales Month = Feb, Show sum of Pipeline for Sign Date between Feb and Apr
Sales Month = Mar, Show sum of Pipeline for Sign Date between Mar and May
..... so on and so forth. There is no relation between Sales Month and Sign Date.
The output I am looking for from the attached QV application is attached as an image.
Thank you in advance for your help,
Dipti
create a link table in your script and use the new field to sum upon :
Sales Month | Dimension |
201301 | 201301 |
201302 | 201301 |
201303 | 201301 |
201302 | 201302 |
201303 | 201302 |
201304 | 201302 |
etc...
Try the bellow expression...
Sum(IF([Sign Month]>= [Sales Month] and [Sign Month] <= [Sales Month]+2, Pipeline))
Thanks,
Pradeep
Pradeep this is a really really bad solution, if I may say so. Please read QV best practises documents where you can see why.