Hello,
I'm having an issue during the conversion of a measure that works on his minimum level to a graphic where I want to group them.
That is the measure:
IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),'ATIVO','INATIVO')
And I have these two that are just the separation of "Ativo" and "Inativo"
Ativo:
IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),COUNT(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)])),'0')
Inativo:
Count(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)]))
-
IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),COUNT(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)])),'0')
When I have the dimension set as "Cliente" I can count the number of registries and see how many "Clientes" I have on "Ativo" or "Inativo", but I cant group them by Estate.
If I select State as my major dimension on a graphic the data is displayed summarizing all the registries considering just the recent date on the state and not counting the dates separatedly.
Can you guys help me?
Thanks!
