Recent content by jjb373

Thank you for the reply. We tried this (I copied my Impromptu.ini file to his location) and it still rendered the same results. It seems like column width settings may be static vs. dynamic because if you remove a column, the footer section remains the same width and any calculations in that...

Tek-Tips community, We curently are using the old version of Cognos Impromptu Version 7.0.702.0 We have other BI tools now but so much is developed in this it is keep the lights on. PROBLEM One of our users is running a report using desktop Impromptu. This report is a formatted report which...

Good afternoon - I have been asked to add a "filtering tab" to an Excel file containing two lists of data and 4 PivotTables (all on different tabs). The goal is to make this file "more presentable" to the audience while providing a better user experience. Here is my summary of the file: 2 tabs...

Please review the below layout for current state and desired state of the data. I am trying to come up with a SAS Script to run to address the need of transposing(creating a cross-tab) a hierarchy dataset. RAW DATA IDNumber Group LetterRating 123 Finance A 123 Sales B 123...

Skip - I understand if the value is a zero then you won't be able to divide. But my scenario is different. I am generating a pivottable and want to take the difference of two measures within the Values section of the PivotTable. My example: row labels contain: group type (ex: teacher...

My scenario is as follows: I have a list of users who have access to a site. When a users visits the site, activity is tracked (basically a hit counter). After bring my data into Excel I am trying to do a quick analysis to show total # of users with access to site by group, # of users who...

Skip - your solution works great. Thank you very much! -- JJB373 --

Basically what I am trying to do is "pivot" the list of sales reps from sheet 2 and append them to new columns within sheet 1 and if a company has more than 1 sales rep, the 2nd sales rep falls into the next column named salesrep2, and so forth up to the 5 columns which could contain the list of...

Glenn - thank you for the reply. I gave this a try with my dataset but I ran into a few problems. I have roughly 3000 unique companies and roughly 125 sales reps. One company can have up to 5 different sales reps from the list of 125. Note: each company is required to have at least one...

All - I am not sure that my subject line explains my situation but here is the scenario. I have a list of companies and for each company a list of sales contacts who the company works with. So, one company may have just one sales contact or many sales contacts. I have an Excel sheet which...

Skip - Thank you for taking the time to reply. I didn't realize I could use TGML Tags.... I completely agree that the matrix that is being desired is pointless. I tried to explain that to them but that is what they want. I see no value added use for it. With that being said, do you (or...

Hello All - In Excel I have a list of employees (attached fig.1). This list can have more employees added to it over time. In Another tab in this spreadsheet, a matrix (attached fig.2) to show where those employees fall regarding certain criteria. I want to be able to run a macro and have...

Tony - Thank you very much for taking the time to investigate this topic for me. Another reason why the users of this site are class A people. Jeff -- JJB373 --

Tony - Thanks for the info again. We will be purchasing from a company. Any suggestions on what brand and model out there will come close to the specs you suggested? Thank you very much for your time. -- JJB373 --

I was informed we are issued new PCs every 3-5 years because we have a lease/contract with IBM. -- JJB373 --