To get this: I used a single field called "Image Date", and created 3 column prompts like this: When you create each prompt, select "column prompt", choose your date field, then use the edit button in the top line, shown below to change it to Year(Datefield) or Month(Datefield). "Month" is shown below, and the second…

Are these prompts on the same page? Do you have a time dimension set up in the data model? If so, put them in the same prompt and constrain month by the year prompt, and date by the first two. If it's across different pages and data models, use presentation variables where you have "???".

Hi, This was just answered yesterday: 4191248 The gist of it is, when using an action link to pass multiple filters, use the "Navigate to a web page" option, not the "Navigate to BI content" option.

Hi "3267774", Robert has already given you the correct answer, and you should mark his answer as such. (I'm not fishing for his points) I just wanted to point out that when you add the action link to the Services column, use the "Navigate to a Web Page" option, not the "Navigate to BI Content". Place your Report B on a…

Hi all, If the analysis is as simple as the one pictured, you can "fake it" with a conditional column and a pivot table. In this example, the "Measure Labels" are hidden.

Hi Farruhk, I'm not aware of a method to do specifically what you've described, but I'm not one of the gurus on here. I missed the fact that you were sending a dashboard, and not just an analysis. Have you considered using a hidden dashboard for the agent? Then, you could set the prompt defaults to values like the ones I…

Hi, If you are willing to change your query filter, the following is a filter I use to do the same thing you are seeking to do: "Contracts"."Revised Contract End Date" BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-1,TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFMONTH(CURRENT_DATE)-1),CURRENT_DATE)) AND…

Have you tried bringing the sort column outside of the union? By that, I mean going to the header level and using the "Add a Result column" option. If it's the fourth column, refer to it as "saw_3" (first column is saw_0). Sort on that instead of the original column. If that doesn't work, add a function to it, like…

You can insert dummy lines right in the analysis using a union. In my case, I added a "Week of the Year" column, a zero value for the graphed column, and null values for all other columns. Filter on the previous year for weeks less than week-of-current date. Use external columns ("saw_x" calculated columns) that sum by…

My solution to this is to set a presentation variable in the employee ID prompt, say "varID". Then, in the filter of the query, insert: UPPER('@{varID}')=LOWER('@{varID}'). In the 'No Results' view, type the custom message "Invalid Employee ID - Numbers Only!" This only works as a test for unwanted alpha characters, (and…

My suggestion was really about the structure of your data model. Setting that aside, another approach would be to construct accumulating columns for each month of the report. I'm assuming you have an "Acquired Date" and a "Loss Date" for each customer. You would create 6 monthly columns of this general formula: September…

Can you pivot your data the other way? If so, the calculated columns become simple:

I don't have an immediate answer, but isn't your illustration incorrect? Should the losses in the Aug-16 and Sep-16 rows be shifted to the right? i.e., Customers gained in Sep-16 can't be lost in July or August of '16.

Are any of your analyses unions? I work in 11.1.1.9.5, but I've found that that can cause problems for master-detail linking. This may not be your problem, but if it is, the solution I've found is that the channel has to be established in the original "leg" of the union, before other queries are added in.

I had to get out of my Inbox view to see the "Correct Answer" button.

I would, but I don't see where I can do that. All I see is "helpful", and "No actions are available".

Thanks Robert. See my comment below, mistakenly posted to my original post. I appreciate the response!

It turned out that my original subtotal method worked just fine, but at some point, I had removed the "Measures Labels" from the column stack. When I replaced it, the dividers appeared as I wanted.

Robert, Nasty, hacky ideas are a specialty of mine. But, in this case, I think I'd have to create a union to get the null column to appear where I want it. Just beyond my tolerance level for a cosmetic treatment. I have tried conditional formatting, but that only affects populated cells. Thanks for your time, Jerry

Sounds like tough sledding, but well done. I did format with html when I used this narrative-view method, but I wasn't concerned with the export difficulties.