Calcite | Level 5

## DYNAMIC COLUMN NAME

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.

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.

3 REPLIES 3
Calcite | Level 5

PROC Star

## Re: DYNAMIC COLUMN NAME

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".

Fluorite | Level 6

## Re: DYNAMIC COLUMN NAME

Crosstab:

Vars:

Crosstab Filter (with parameter):

*The Drop Down contains datetime parameter.

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