COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: saturnz on 01 Sep 2017 09:10:32 AM

Title: crosstab total with topcount axe
Post by: saturnz on 01 Sep 2017 09:10:32 AM
hello,

i work with dimensional package
to list top20 stores crossed by their sales in tuple with time analysis (N, N-1 and vs N-1 made in the cube)

i've got a problem with automatic summary for some columns and i don't know why
it's the same kind of kpi
i only change the format in the two last columns, it made a total of % instead of aggregation, i should have 73% instead of 1877
how can i do that ?

please see document attached

thank you