en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Maria Rømer  
#1 Posted : Monday, April 30, 2018 7:25:03 AM(UTC)
Maria Rømer
Rank: Newbie

Groups: extranet\Forum
Joined: 4/30/2018(UTC)
Posts: 1

Hi,

I have a crosstab which doesn't allow me to make intersection based on my calculated column instead of my calculated rows. How to solve that?

TOTAL TOTAL Invoiced Budget CALC-INDEX % CALC-ACC.INVOICED CALC-ACC.BUDGET CALC-ACC.INDEX %
Salesperson 1 Total
January
February
March
April
May
June
July
August
September
October
November
December
Salesperson 2 Total
January
February
March
April
May
June
July
August
September
October
November
December
CALCULATION JANUARY
CALCULATION FEBRUARY
CALCULATION MARCH
CALCULATION APRIL
CALCULATION MAY
CALCULATION JUNE
CALCULATION JULY
CALCULATION AUGUST
CALCULATION SEPTEMBER
CALCULATION OCTOBER
CALCULATION NOVEMBER
CALCULATION DECEMBER


BR,Maria

Edited by user Monday, April 30, 2018 7:34:53 AM(UTC)  | Reason: Not specified

Ole  
#2 Posted : Monday, April 30, 2018 6:45:53 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 412

First, check that you haven't already made the opposite choice: Intersection calculation of columns based on rows or vice versa. You can only do it one way at a time.

Secondly, it can only be done between true calculated rows and true calculated columns - i.e. it will not work for columns inserted "as a new measure".

Third, check your calculations for unnecessary modifiers such as "(v)". Sometimes these will prevent "calculate in intersection".

If none of these suggestion will work, you may need to provide further details (screenshots).

Best regards,
Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok