Need to show daily sales, monthly sales, Yearly sales in a List after selecting

[Kiran Kandavalli]

Hi Everyone,

Can any one suggest me?

1) I have a Date prompt in prompt page

2) By selecting the date in Date prompt, we need to show the daily
sales and Monthly sales and Year Sales of a product in a list.


Thanks and Awaiting for your reply,
Kiran

[navissar]

If you're over dimensional (DMR or Cube) use the built-in family functions to achieve that.
If you're over relational, your life is much more difficult, but still possible. Use the date functions to extrapolate the year and month from the parameter, and create three queries - one filtered by day, one by month and one by year, containing Sales and product name.
Join two of them together based on product, and the join the third one to the joined query based on product, then use the query that is the result of that as you list query and drag in the sales fields. Performance may be shaky, but it's supposed to work.