COGNOS: Calculation in a cross table based on condition from other dimension
. Hello all,
does anyone now if there is a function to calculate a measure based on 'Assets' with the condition of "Profit Center Contribution" or "Funding Center Contribution". (see image below)
Thanks in advance
Solution
If you are using a DMR model you could use the tuple function. Assets -FCC= tuple(Profit Center Contribution, assets, currentmeasure)
- Reporting tools compatible with Genexus
- VBA code to generate report based on combobox variables
- Power BI to users without Power BI
- How to add a pound symbol(£) before the formula in textbox
- Why doesn't Mocha report time for every test?
- Derive values from previous Quarters
- 'Back To Parent' not showing on Reporting Server 2016 after migrating from 2008
- Exception generated when trying to generate jmeter HTML reports
- Adding expect value to Playwright html report
- How to make RowNumber (local report) work in this case?
- Writing VBA to take data from multiple sheets, organize them side by side chronologically downward (timeline) comparing the dates on multi-tables
- Adding a subreport to rdl table cell
- How to get more junit-failed-details in gradle log without running gradle in debug mode
- how to create a textbox in ssrs for user entry as a parameter and limit the Character input to 18
- How do I find out where this error is coming from?
- PowerBI remember filters when opening new report from another report
- Google GA4 Report for Event with Event Parameter
- in report, repeat only certain columns after first row
- How to merge two or more table from different databases to generate a report in PowerBI?
- Jasperreports multiple subreports overlapping
- getSharePointSiteUsageDetail Report does not return Site URL
- Automating Power BI Queries Across Multiple SQL Server Databases with Identical Schemas
- How to Print contents of datatable in HTML in printpreview and direct print including headers/Set paper/Orientation/Fit to Page/Grandtotal in VB.NET
- How do I get a summary count of missing/NaN data by column in 'pandas'?
- What is this graph called?
- Change output directory of maven surefire-plugin
- The type or namespace name 'Reporting' does not exist in the namespace 'Microsoft'
- How do I group data in an ASP.NET MVC View?
- SSRS Report in Web App clearing out Session variables?
- Salesforce extract report to FTP location