Skip to Content
avatar image
Former Member

Problem In Cross Tab Webi report

Hi Folks,

I have urgent requirement in web intelligence. I want to show 2004 Quantity Sold values in both 2005 and 2006.

screenshot-499.png (94.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 14, 2017 at 03:21 PM

    place this formula in Quantity Sold column.

    =[Quantity sold] Where ([Year]="2004")

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 03:26 PM

    do you want to show the quantity sold in 2004 + 2005 or just qty sold in 2004 in a cell? If its the first condition you can do it as shown below or if its other way around then go with Amit's suggestion.

    = [Qty] where ([Year]="2004") + [Qty] where ([Year]="2005")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2017 at 06:50 AM

    Hi Amit Kumar & Kuldeep Ghosh,

    Thank you!!!

    As you said, I tried and got output.

    I want to show 25/12/2015 Quantity Sold values in both 26/12/2015 and 27/12/2015

    Now i need output for below query

    =[Quantity sold] Where ([Date]='25/12/2015')

    above query i tried but i didn't get output.

    25395-screenshot-503-2.png

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 07, 2017 at 01:07 PM

    Hi Rajesh,

    It may not be the ideal way of calculating measures, looks like too much manual work. Apart from that discussion, the formula would be
    =[Quantity Sold] where ([Date]=todate("25/12/2015";"dd/MM/yyyy"))
    If you get an error, try using the date "12/25/2015".

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded