Crosstab - Query - Percentage

[dunno]

Hi all (novice here)!

Here is how I've setup my crosstab in cognos 11 (report):


The Count is my measure.
I have everything working besides the column Difference.
I tried creating the following two queries, but nothing worked out:

• Aggregate([Count] for [TypeOfProduct])
• Aggregate([Count] for [TypeOfProduct], [LastYear]) - Aggregate([Count] for [TypeOfProduct], [ThisYear])

Any hints?

[srmoure]

Are you using a relational or a dimensional model ?

[chr.93]

Hi all (novice here)!

Here is how I've setup my crosstab in cognos 11 (report):


The Count is my measure.
I have everything working besides the column Difference.
I tried creating the following two queries, but nothing worked out:

• Aggregate([Count] for [TypeOfProduct])
• Aggregate([Count] for [TypeOfProduct], [LastYear]) - Aggregate([Count] for [TypeOfProduct], [ThisYear])

Any hints?

Hello!
An approach that I usually use in cases like this, is to create one query for the current year, one for the last year and to joined them in a third query(let's call it joined)
Then you will drag in the crosstab all the fields from both queries and create the difference in th Joined query.