BookmarkSubscribeRSS Feed
Lorena1w
Calcite | Level 5

Olá 

Gostaria de saber se seria possível colocar o nome das colunas dinâmico. Considere a seguinte situação:

Suponhamos que fizemos as duas colunas calculadas – medidas - (Venda Atual e Venda Anterior). Teremos um filtro de ano, ou seja, se o usuário escolher um ano = 2016, teríamos o seguinte cenário:

Venda Atual = Venda do ano selecionado. No caso, uma venda referente a 2016.

Venda Anterior = venda ao ano selecionado -1. Ou seja, a venda referente a 2015.

 

Considere que o gráfico selecionado foi uma tabela de referência cruzada.

Teria como o nome das colunas (venda Atual e Venda Anterior) serem dinâmicos. Ou seja, aparecer (Venda 2016, Venda 2015), considerando que o usuário selecionou 2016 no filtro.

 

----------------------------------------------------------------------------------------------------------------------------------------------------

 

Hello

I wonder if it would be possible to put the name of the dynamic columns. Consider the following situation:

Suppose we have made the two calculated columns - measures - (Current Sale and Previous Sale). We will have a year filter, that is, if the user chooses a year = 2016, we would have the following scenario:

Current Sale = Sale of the selected year. In this case, a sale related to 2016.

Sale Previous = sale to selected year -1. That is, the sale related to 2015.

 

Assume that the selected chart was a crosstab.

It would have like the name of the columns (Current sale and Previous sale) to be dynamic. That is, to appear (Sale 2016, Sale 2015), considering that the user selected 2016 in the filter.

 

 

ex.pdf.PNG

3 REPLIES 3
Lorena1w
Calcite | Level 5
SASKiwi
PROC Star

The only suggestion I can think of right now would be to add a dynamic text object above your cross-tab that is linked to your filter so it would display the filter value like "Sales 2017 versus 2016".

Creeback
Fluorite | Level 6

Crosstab:

 

Crosstab.png

 

Vars:

Var.png

 

Crosstab Filter (with parameter):

 

Object Filter.png

 

*The Drop Down contains datetime parameter.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 931 views
  • 2 likes
  • 3 in conversation