Comparison Help - TARGIT Decision Suite - help & get help

Comparison Help

Options

Gemma International - Chris Campbell

#1 Posted : Monday, June 18, 2012 10:05:37 AM

Rank: Advanced Member

Groups:

Joined: 3/28/2011
Posts: 21

Hello

I was wondering if anyone can assist with this query.

I've an analysis which shows the measures Invoices, Credits, Total Sales & Budget against Salesperson

I have created a comparison which shows both current month and year to date.

In the current month I want to show all the measures, however in the year to date I only want to show total sales & budget.

Is this possible to do?

Thanks

Chris

Chris Campbell
Gemma International - Andover UK

Report Abusive | Report SPAM | Edit by moderator: Wednesday, July 11, 2012 8:10 AM | Reason: Not specified

User Profile
Hide User Posts

TELMORE - David L. Bojsen

#2 Posted : Monday, June 18, 2012 10:30:04 AM

Rank: Member

Groups:

Joined: 4/5/2011
Posts: 6

chrisc@gemma-international.co.uk wrote:

Update - 18-06-2012 14:54

Clearly I was wrong - I was not aware of this possibility.

/ David

Hi Chris

This is only possible to achive, if you hide all your measures and the create calculations instead.
Your calculates columns will then be:
Invoices MTD - Credits MTD - Total sales MTD - Budget MTD - Total sales YTD - Budget YTD

You cannot hide a measure in a surtain context.

/ David - TELMORE

Report Abusive | Report SPAM | Edit by user: Monday, June 18, 2012 1:55 PM | Reason: Not specified

User Profile
Hide User Posts

Gemma International - Chris Campbell

#3 Posted : Monday, June 18, 2012 10:30:37 AM

Rank: Advanced Member

Groups:

Joined: 3/28/2011
Posts: 21

Solved - Mikkel was able to advise me straight away

In the visibility propertied you can "Hide A Range For A Comparison" in the same way as you can with dimensions.

Chris Campbell
Gemma International - Andover UK

Report Abusive | Report SPAM

User Profile
Hide User Posts

Users browsing this topic

- Anonymous