Joined: 28 Aug 2008
Online Status: Offline
Posts: 20
Topic: Repeat row value in Cross-Tab Posted: 06 Mar 2009 at 7:28am
I have a Crosstab made in CR XI that shows Period values in the columns and country and customer in the rows. The problem is that when I export it to Excel, the country is only shown once, if several customer belongs to that country. I would like to have the country shown for every single customer, is that possiblem?
Please create a new formula field. In this formula field, joint all selected column i.e. column1 & column2 & column3. This will create a field which has all distinct values and include this field in your report. No all required values will repeat in each row as you like. Regards
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