The way you have described the chart (revenue in X axis and profit in Y axis) you could use a scatter plot with quarter in the color role or in the lattice role: [cid:image001.png@01D6232E.450CE8B0] Technically you could also use a numeric series, but I don't think it would fit in this use case. Or you could try something different, as this parallel coordinates chart: [cid:image002.png@01D6232F.29851170] ... View more

Thanks Victor.    To create a track or otherwise contact Tech Support, go here:   https://support.sas.com/en/technical-support/contact-sas.html   Sam ... View more

Hello Victor,   One approach would be to create a button bar with a 'helper' category assigned to it, where the helper category has the values 'Sales' and 'Quantity'. You would also assign a character parameter to this button bar.   Then, you would create a calculated item that would look something like this:   IF ( 'helper'p = 'Quantity' ) RETURN 'Quantity'n ELSE 'Sales'n   And when this calculated item is assigned, we get a result like this:   Depending on the button bar selection, the chart will show the data from either the Quantity measure or the Sales measure.   Now, the drawback to this approach is you can only assign one label, one format, and one aggregation for the calculated item. But this might be fine if the data are similar.   Let me say here that I am not an expert on all the workarounds of report building, and someone else may have a better way to implement the above approach.   The much simpler alternative is to use a stacking container with separate objects for the two measures. Here, there are separate charts for Quantity and Sales, but only one is shown at a time depending on which item in container is selected.    Hopefully one of these approaches will work for you. Let us know!   Thanks, Sam ... View more

That's what I thought also, but the date format is not available :     And I also tried to re-create a calculated item from the numbered date format to a real date format using but then the behaviour comes back to the detailed view and not the (max) date. ... View more

Any idea ? 🙂 ... View more

One thing to check is that your login IDs in your data has been UPCASED. On our environment the SUB :: SAS.UserId returns a UPPER CASE value so I assume that's the case everywhere. If your data contains 'myuserid' then either change it to MYUSERID or use the UpCase function on your login category. To use UpCase in conditional grants you'll need to apply it through the batch tools since the editor doesn't have it listed under the Text(Simple) operators.    BTW -- I'm the Jason in the paper you reference.  🙂 ... View more