on 07-30-2021 2:03 PM
Hi,
I've been working on EPM for a week and there's a problem I can't solve. I've two columns(actual and plan) for data with the same date on the report. But, I don't want to same date to occur twice. Merge column button is NOT active. How can I overcome this?
Let me show you what I want by photo.
1: Current situation
2: Situation I want.
Best regards,
Tuncay.
Merge cells is not supported in EPM reports.
If you uncheck "Repeat column headers" in report options then you will have date only in first column like:
20200730
ACTUAL PLAN
No other solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have had to overcome this same requirement for lots of reports. The best way to accomplish this is to use "row grouping" in excel on the row that has your date. Then in the cell above that, you can link to the column header on the report. This cell is not a part of the report, but then you can hide the actual report row with the date by collapsing the row grouping. You will want to make sure the "Keep Formulas Static that Reference Report Cells" is turned on in your sheet options, otherwise you will get "#REF" errors if you change the date and refresh the report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.