Help me with ideas to address a challenging report

[qvixote]

Hello!

I hope you don't think the tittle was a click-bait if you think the report is not challenging enough  ;D



I need to make a report like the image above, over a Transformer PowerCube. The cube already has the following (names are in spanish, but I think it doesn't prevent understanding the problem):

DIMENTIONS:
- Nombre de vacuna
- Dosis
- Grupo de Edad
- Month

MEASURES:
- Vacunas administradas
- Población

Need to accomplish the following:

• "Cobertura" is a calculated column: "vacunas administradas" / "población", but only with total at "Dosis" (in the above image, total rows are light blue and are placed above, not bottom).
• "Vacunas administradas" total at "Dosis" must SUM all "Grupo edad" except last one, wich is always "Fuera de cobertura". Ex.: In the above image, for "BCG - Única - Enero", "Vacunas administradas" is 225, because is adding only 215 of "Recien nacido" and 10 of "Menor de 1 año", but ignoring 3 of "Fuera de cobertura".
• "Población" measure need to be visible only for total row.

I'll post the results of my attempts soon.

It's also possible to send someone the powercube.

[Andrei I]

You would get a much better response and support if you try to do a similar report using a Cognos Sample PowerCube.

[qvixote]

Believe when I say I did think of that, but I don't have the samples installed and installing it is not an option. I'm trying to find an MV with the samples I think I have.

But I can share the powercube file, you can download it here: https://www.juanilabaca.cl/dl/dbvp_cobertura_2017.mdc.

[Andrei I]

I assume you know how to use dimensional functions.
You would have to play with filter one.
If you need exact expression then I think you should build your report against Cognos sample cube rather then ask everyone to configure your cube :-)

[qvixote]

I think the same  :-[

Tomorrow I will have a MV with cognos and samples, and I'll do it that way, then make a new post.

Thanks!  ;)