Skip to Content

webi report level filters and input control

I have an issue I have a date field in my report and I used that date field as my report filter (prompt). But here we have 5 tabs in a report each tab showing different data based on that filter (prompt) But it has to show different values for different data But it is showing same data for all tabs: My issue is can one date field filter can act different ways Example I am entering 2017 date

But I have 3 different tabs 1 tab is CUSTOMER 2 tab is PRODUCT 3 Order date

But I am entering only single date field it has to show many ways

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 02, 2017 at 08:31 AM

    Hi,

    the date filter will filter out your data accordingly and the other dimensions will show the amount (sum) always the same, but it would show different values for multiple dimensions value, I mean

    YEAR Customer PRODUCT AMOUNT

    2017 001 A 100

    2017 001 B 50

    2017 002 A 300

    IN report tab customer

    CUstomer Amount

    001 150

    002 300

    Total 450

    In report tab product

    Produkt AMount

    A 400

    B 50

    Total 450

    Add comment
    10|10000 characters needed characters exceeded