How to left join on pivot table

[Brett]

Hi @tomer1,
So if I understand correctly, you’d like to create a static field that lists all sources, so even if a specific location/clinic does not have that source, it will still be on the list?

There have been a couple other recent posts that were similar to this request, take a look at the posts below and let me know if one works as a solution for your case:

Static Table for Visualization

Hi @Giridhar.Prabhu, Transforming the Booked Channel field into a new field that only shows individual channels isn’t exactly possible but a work-around you could use is to setup a denseRank calculation, partitioned by channel, and filter down to 1 row per channel type (just rank 1s). Then you could use LAC-W calculations, like sumOver, to retrieve your values for the Booked and Reported fields. Once again partitioning those fields by the booked channel field to ensure they are grouped appropr…

How can I build a minimum and maximum range table in quicksight

Hi @jcolucci It appears your {Unit Value Amount_USD} is using an aggregation function (SUM ?). Looking at your requirement it seems you could put your rows at the lowest level into these different brackets and your calculated field in that can be just the value at the lowest level. Alternatively, you may need to use Level Aware Calculations to get the computations return a value at the row level. See a similar issue resolved here. Regards, Giri