Hi David,
The percentage operation that you're looking for is only available when you're using a dimensional source, e.g. an OLAP cube or a Dimensionally Modeled Relational source defined in a Framework Manager model.
The UI of Reporting would look like:
If you're using a relational source, modeled either with Framework Manager or as a Data Module. Then you can still accomplish what you need.
Here is an example.
Each axis contains a dimensional attribute. <Order Method En> and _year(Order Date) and there is one measure.
Please note how it uses a nominator <Quantity> and a denominator; total ( <Quantity> for <Order Method En> ), the latter is the total for each distinct <Order Method En>, i.e. it is a row_total.
Apply a formatting option to the crosstab cell, I used percentage with 1 decimal
The output looks like:
Hopefully this helps.
// Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Mon March 23, 2020 10:29 AM
From: David Willis
Subject: Re: Crosstab showing percentages
HI Everyone and thank you in advance for replying.
i am using Cognos Analytics 11.0.13.1 (LTS).
i have build a report, a cross-tab, this following information is in this;
- Category (departments in my team)
- Measure = (the number of records completed by each team)
I want to be able to report the activity in the measure as a percentage.
I have tried to write the query expression but I keep getting errors, however I found and tried to apply the guidance as per the link I have supplied and I am not able to see the same options as detailed.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_reprting_show_xtab_val_as_perctge.html
I get to step 2. and the option to show values as a percentage is not there?
Thank you in advance
------------------------------
David Willis
------------------------------
#CognosAnalyticswithWatson