Skip to Content

Croostab Differences Calculation column position and formulas

Hi,

I created a croostab report with [As_Of_Date] column, [Current Balances] Values and [Products] rows. Now I put the Differences Variance for the columns but does not allow me to move the columns and if you change the dates of selection displays an error of arguments. I check this in the Calculate Member formula and the issue is when the As Of Dates changes then cracks the formula because the formula recorded previously CDateTime (2017,2,6,00,00,00).

On the other hand i need to be able to move the columns of Differences to the left.

I Saw this post https://archive.sap.com/discussions/thread/3434351 for Abhilash Kumar and it's works but generate a difference column calculation for the next column of As of date.

The Differences calculation must be:

{Yesterday}-{Before Yesterday} Like 2/6/2017-2/3/2017

{Yesterday}-{Last Month Date} Like 2/6/2017-1/31/2017

{Yesterday}-{Last Year Date} Like 2/6/2017-12/30/2016

{Yesterday}-{Oct 7 2016} Like 2/6/2017-10/7/2016


See that I need crosstab-sample.gif

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

17 Answers

  • Feb 10, 2017 at 08:20 AM

    Hi Luis,

    Please attach the report with 'saved data'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:23 PM

    Thanks for your reply,

    Let me know how to upload the file .rpt? Is not a valid extension file.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:24 PM

    The application not accept this extension format. Let me know how I share the file report.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:25 PM

    Give me your email to send the file.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:25 PM

    Give me your email to share the file report. Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10, 2017 at 10:15 PM

    Hi Kumar, Let me know to send to you the file.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:27 PM

    Hi Kumar, Let me know how to share the file rpt. I try to Upload but the Web do not accept this extension.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 04:27 PM

    Hi Kumar, Let me know if you provide me any email for share the report.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2017 at 03:29 PM

    send me an email to to share the file.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2017 at 03:02 PM

    Hi Kumar, I can't share the file by the Web is not accept the upload.

    Add comment
    10|10000 characters needed characters exceeded