Skip to Content
author's profile photo Former Member
Former Member

show sum value comparing different field in webi

Hi Experts,

I am facing an issue in calculating amount comparing year from one query and year from other query.

Data that I have is

here Supplier, a_year is coming from query1 and Fiscal year and payment is coming from query2.

I have to show Supplier, a_year and Payment in table where payment should be summed up based on Fiscal Year values

Means Fiscal year 2015 value get summed up and shown on a_year's 2015 similarly 2016 value.

Please guide me how it can be done.

Thanks,

Ankit

result.JPG (21.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 01:22 PM

    Any solution on above issue......please help.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2016 at 01:57 PM

    Merge the Fiscal Year & a_year objects and create detail variable for Supplier.

    Drag Merged Year object with Detail supplier variable and Payment and see.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.