-
1. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Joshua Milligan Jan 25, 2013 9:20 AM (in response to ravi.vankayala)Ravi,
It could be a simple calculated field like this:
//Assuming [Parameter] is a date type and [Date] is the field in your data
[Date] <= [Parameter]
Then, you'd put that calculated field on the filter shelf and set the filter condition to true.
But, it's a little hard for me to say if that's the right specific answer to your question. If it is not, would it be possible for you to post a packaged workbook, or at least some sample data? (Even dummy data in the same format, if your data is sensitive).
Joshua
-
2. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Tracy RodgersJan 25, 2013 9:29 AM (in response to ravi.vankayala)
Hi Ravi,
If your parameter is a string parameter with values similar to 2009 Q1, 2009 Q2, etc. then, the calculation may look similar to the following:
(if [Choose your Quarter Parameter]>=(datename('year', [Order Date]) + " Q" + datename('quarter', [Order Date])) then
[Order Date] end)
Hope this helps!
-Tracy
-
3. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Shawn Wallwork Jan 25, 2013 10:08 AM (in response to Tracy Rodgers)Hi Tracy, long time no talk to, hope all is going well!
Could you post a workbook that shows how your formulas works, I'm just not getting it? Thanks,
--Shawn
-
4. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Tracy RodgersJan 25, 2013 10:17 AM (in response to Shawn Wallwork)
Same to you Shawn! Sure, here's the workbook I made using Superstore.
-Tracy
-
choose your quarter.twbx.zip 23.1 MB
-
-
5. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Shawn Wallwork Jan 25, 2013 12:22 PM (in response to Tracy Rodgers)Thanks Tracy, now I get it. You and I interpreted the question differently. I thought Ravi wanted current quarter and previous quarter ONLY returned. You understood it to be current quarter and ALL previous quarters, obviously, because that's what you coded [or "a la mode-ed", I guess.] And a happy TGIF to you!
--Shawn
-
6. Re: I need calculation for displaying data for previous quarters.Please can anyone help
ravi.vankayala Jan 25, 2013 11:58 PM (in response to Tracy Rodgers)Hello Tracy,
thank you for your reply.
I have created calculation but when i am dragging it to the text field i am getting CNTD instead of sum.Is there any way to get aggregation SUM ? i have created calculation where i need to give some condition using some text data also.
it showed error as "can't add float and string values". so i have added STR to dimension to resolve the error and also changed from cntd to ATTR but i am not able to generate axis because of ATTR.
We can get AXIS only if we aggregation SUM.
-
7. Re: I need calculation for displaying data for previous quarters.Please can anyone help
Tracy RodgersJan 29, 2013 3:54 PM (in response to ravi.vankayala)
Hi Ravi,
Would you be able to post your workbook (twbx file)? Or a screenshot of your view and calculation?
-Tracy