Total per Category on Dynamic Table

[vinicius_siquei]

Folks,

I have the table below in my application.

On the last column I need to to present the share information. To do that I need to have the Total for every record within each category (GrupoModeloVeiculo). For instance, in the image all records from Big Sport Touring Category should present the Total of 12.

I'm trying to do this by using the following set analysis expression :

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}, GrupoModeloVeiculo=>}Numero_Chassis)

I had the expectation that GrupoModeloVeiculo= would make the expression ignore the GrupoModeloVeiculo dimension and give the total, however its not happening. Could anyone help me ?

Could anyone help me ?

Thanks

[#2]

Hi,

Perhaps the GrupoModeloVehiculo is a dimension that is linked to other dimensions that are limited.

That is the same with TIME: if you do a set analysis on Month (with = to get all months) but do nothing on Quarter or Years, you have done almost nothing.

Fabrice

[Nicole-Smith · Accepted solution]

If you want to ignore dimensions, you need to use TOTAL:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>} TOTAL Numero_Chassis)

If there are dimensions you want to include, do so like this:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>} TOTAL <DimensionToInclude> Numero_Chassis)

[vinicius_siquei]

Nicole,

Your suggestion worked perfectly! Thanks for you help!

The final expression was:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>}TOTAL <Segmento> Numero_Chassis)