I'm not clear on what you mean by "The logic should be implemented with Current_date & Award Date". If you mean that you want the 12 weeks preceding the current date, and all others go into a 13th column, then it would look like this: (I'm calling the all other column 'Earlier') case when "Contract"."Award Date"…

Do you have a time dimension associated with this date field? One that contains week-of-year? If so the pivot table would be pretty straightforward to duplicate your illustration. Otherwise, you can do some timestamp gymnastics to bin the dates into the Saturday date labels for the weeks: case dayofweek("Contract"."Award…

Normally, the calculated column you describe should work correctly, even in a union query. Have you set a aggregation method in the formula dialog? Alternatively, you can do the calculation "outside" the union, at the header level. When you highlight the header level of the union, there is a "add a result column" option.…

How about hidden sort columns? One with a UPPER fnx applied, so it is case-insensitive, with two views,each using the separate sort columns. A view selector could provide the sort options.

You need to provide more information. Is this a BI Publisher report, or an OBIEE analysis? If it's the latter, you can construct a pivot table to display the data as shown.

If you have a javascript solution that works in 12C, on the Results tab, select the New View icon, then Other Views. You can use either the Narrative View or the Static Text View: Place the js in the view and select the "Contains HTML Markup" box: Place the new view at the bottom of a compound view that contains your pivot…

Thanks for the lesson! I don't deal with much personal identification data. Jerry

Hi Steel, Would it be simpler to use string functions, as in: REPEAT('X',(LENGTH("cc#")-4))||RIGHT("cc#",4)? Jerry

Hi NagarajanK, Sorry that I misunderstood your question. I don't have an answer for you, because that javascript solution that you cited doesn't work in 12C, and I'm not a js guy. If you get a corrected script, you simply place it in a narrative view, check the "Contains HTML" box, and place it at the bottom of a compound…

Select "Format Heading" from the column edit options. You can type in any heading you want, including a blank space. Also specify the background color.

I just answered this exact question from "3715500". Here's my answer: "All Column values" passes a null value to the filter. In your filtered column, you can try a case statement along the lines of: CASE WHEN '@{order date}'='' THEN sum("sales Price") ELSE Filter( "Sales price" using "order date" in (@{order date}) ) END…

Did you change the position of your Measure labels? Also, My last advice may not work. The calculated Item will just total the percentages, not recalculate them. In this simple example, the Column totals are correct: But in your case, the complexity of dealing with unions is showing its ugly head. Another approach gets…

An option: In your pivot table try un-checking the totals you are using to create your Grand Totals columns, and in its place, Click the edit icon for Qtrs, and then "Create a calculated item". in the dialog box, put 'Qtr1'+'Qtr2'+'Qtr3+'Qtr4'. You can name it Grand total. This may produce better results.

I'm a bit confused again. How do the "All Weeks" rows differ from the Name Totals? It seems redundant. If it's necessary, you can repeat the 'All Weeks' query, and put a formula in the Name column like: "Table"."Name"||' Total'. You'll have to do more conditional formatting, and possibly add a column to keep them sorting…

If the separate queries in the union are independent of each other, the "All Weeks" percentages shouldn't have changed. The main purpose of the text label column that I mentioned is to separate the results. So, if column 1 (let's call it Bin) contained values of 'All weeks', 'GrpA', and 'GrpB' in the 3 queries, you use…

I had assumed the "Qtrs" were calendar quarter, so you can see how unclear it was for me. Starting over, If the whole example is a football season, then I have to assume a single record looks something like: Week, Qtr, Name, Attempts, Completions. Because your GrpA and GrpB can overlap, I believe it has to be a union of…

Hi Tom, Can you provide more information about your data? You've described your table as covering weeks 1-10, but you're results show quarters 1-4. Are Quarter and Week coming from a structured time dimension? You've described your desired results in detail, but not what you're working with. Jerry

Before abandoning the union query you built, I'm curious about whether it was a two-leg union or a three-leg union. In analogous situations, I've union-ed one query for Grp A, one for Grp B, and a third for "All Weeks". The "All Weeks" query contains its own calculations on the whole time period, so the row percentages are…

How about: ifnull(Raw Materials, MAX(Raw Materials by Item Number)) ?

No. Add a column to your analysis containing 'WhateverTitle'. Then in column properties, set Interactions to Action Link, where you set up the navigation to your target content. Create and format a a single-column Table, Static Text, or a Narrative view containing only the 'WhateverTitle' column. Use that view as your…