0

I would like to create report as below:

https://i.sstatic.net/b5VCe.png

The first section of columns contain costs of:

  • November 2020
  • November 2021
  • November budget 2021

The second section of colums contains costs accumulated of:

  • 11M 2020
  • 11M 2021
  • 11M budget 2021

The first section and the second section of columns should be based on parameters. I would like to get data for current month and accumulated from begining year choosing the data from parameters. On the end of section should be calculation: act/buget -1

My code:


SELECT  LEFT(MIESIAC_BI_ID, 4) AS ROK
       ,MIESIAC_BI_ID AS MIESIAC
       ,B.MPK_1_NAZWA AS OBSZAR_MPK
       ,B.[MPK_2_NAZWA_KONTO] AS MPK
       ,C.[OBSZAR_KOSZT_NAZWA] AS OBSZAR_KOSZTU
       ,D.[DESCRIPTION_NAME] AS OPIS
       ,WYKONANIE
  FROM [Le_crd].[dbo].[F_WYKONANIE_BI_4_5_KO_PROBA] A
  INNER JOIN W_MPK_BI_PROBA B
  ON A.MPK_BI_ID = B.MPK_BI_ID
  INNER JOIN W_RODZAJ_KOSZTU_BI_PROBA C
  ON A.RODZAJ_KOSZTU_ID + '_' + A.RK_ID = C.RODZAJ_KOSZTU_ID
  INNER JOIN [Le_crd].[dbo].[W_TRESC_BI_DOK_PROBA] D
  ON D.ID = A.ID_D
  WHERE (LEFT(MIESIAC_BI_ID, 4) IN (@YEAR)) AND WYDZIAL_ID = 'WL'

As a result I am given below data:

https://i.sstatic.net/vboTA.png

For that moment I have created matrix report:

https://i.sstatic.net/W20Vk.png

Now I would like to for the first column by parameter get current month data and for the second aggregated data from begining of year.

Fisrt column eaual October Second column equal 10 Months

For that moment I am given date for 2022 for 12M and for 2023 for 10M and in second column the same result, but I would like to get October 2022 and October 2023.

https://i.sstatic.net/fagpa.png

How to define for each column different parameter?

Improve this question
6
  • show us your query and your working.. there is no way any one can help with such a vague request! Commented Oct 23, 2023 at 19:57
  • I've just edited. I hope everything is clear. Commented Oct 23, 2023 at 20:37
  • How are you grouping your data? You need to group by some source data column to get a sum for that type right? Commented Oct 23, 2023 at 21:59
  • I'm not sure how to group to achieve expected result. When I tried to group by month I am not able to assign the parameters one for each column (for the first column current month and for the second column aggregated from begining year to current month) Commented Oct 24, 2023 at 8:31
  • From your first screen shot, it looks like you simply need a Matrix report with the rows grouped on MPK1... and the colum group by the date and the data would be WYKONANIE. This will automatically sum the WYKONANIE for you! Commented Oct 24, 2023 at 19:47
Related questions
0
DataSet - How to retrieve values from grouped columns?
0
Order SSRS Report by Dimension property in MDX
0
Fiscal year and month parameters
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.