-
1. Re: Query on Date
Peter FakanFeb 3, 2019 1:16 PM (in response to Anita Deshmukh)
Hi Anita,
Grateful if you could upload a .twbx showing your working so far.
Peter
-
2. Re: Query on Date
Anita Deshmukh Feb 5, 2019 3:19 AM (in response to Peter Fakan)Hi Peter,
I am not able to upload the twbx file due to security constraints even though its using sample superstore data only. It would be grateful if you can you give the generic solution.
The workbook I am using contains the Order date and ship Date on Column shelf. And in row shelf I have used Sum[sales] and Sum[Profit].
I would like to show Sum[Sales] respective to Order date and Sum[Profit] according to ship date. I know we can use Pivot but is there any other way to achieve the same.
Also I have 2 parameter start date and end date and if my end date is Today's date and in Superstore database , there is data till 2017 but then also it should show data as constant for 2019 .It should show the last sum[sales] or profit for today's date also.
Thanks,
Anita